单选题What view might you use to try to determine how long a particular backup will take?（）AV$SESSION_EVENT BV$SESSION CV$W0041ITSDV$WAITSTAT EV$SESSION_LONGOPS
单选题
What view might you use to try to determine how long a particular backup will take?（）
A
V$SESSION_EVENT
B
V$SESSION
C
V$W0041ITS
D
V$WAITSTAT
E
V$SESSION_LONGOPS
参考解析
解析：
暂无解析
相关考题：
Whatviewmightyouusetotrytodeterminehowlongaparticularbackupwilltake?() A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SESSION_LONGOPS
You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）A、Update the view to use an outer join between the Customers and Sales tables.B、Create a clustered index on the v CustomerSales view.C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.D、Create a stored procedure for the business analysts that uses the v CustomerSales view.
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（） A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）A、V$SESSION B、V$SYSSTAT C、DBA_SEGMENTS D、V$SORT_USAGE
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）A、Define user profiles and set the CPU_PER_CALL limit. B、Define a SWITCH_TIME for a plan in the Resource Manager. C、Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. D、Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
Which view provides information on the backup status of the datafiles in the database？（） A、 V$BACKUPB、 V$BACKUP_STATUSC、 V$BACKUP_DATAFILED、 V$DATAFILE_BACKUPE、 V$TABLESPCE_BACKUP
What view might you use to try to determine how long a particular backup will take?（）A、V$SESSION_EVENT B、V$SESSION C、V$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS
Which view provides information on the backup status of the datafiles in the database?（）A、V$BACKUPB、V$BACKUP_STATUS C、V$BACKUP_DATAFILE D、V$DATAFILE_BACKUP E、V$TABLESPCE_BACKUP
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SYSSTAT
You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（） A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
What view might you use to try to determine how long a particular backup will take？（） A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SESSION_LONGOPS
You need to recommend a backup strategy for Hyper-V. What should you recommend？（）A、Take a snapshot of each VM， and then run a full backup of the Hyper-V hosts by using Windows Server Backup.B、Shut down the VMs，and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.C、From each VM,run a full backup by using Windows Server Backup， and then run a full backup of the Hyper-V hosts by using Windows Server Backup.D、From each VM,run a full backup by using Windows Server Backup. Shut down the VMs， and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.
单选题You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.
单选题In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SYSSTAT
单选题There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）ADefine user profiles and set the CPU_PER_CALL limit. BDefine a SWITCH_TIME for a plan in the Resource Manager. CCreate a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. DCreate a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
单选题Which view provides information on the backup status of the datafiles in the database？（）A V$BACKUPB V$BACKUP_STATUSC V$BACKUP_DATAFILED V$DATAFILE_BACKUPE V$TABLESPCE_BACKUP
单选题What view might you use to try to determine how long a particular backup will take？（）A V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SESSION_LONGOPS
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）Acreate a backup of the database and recover all corrupted blocks found in the backupBrun a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseCrun a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewDrun a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewErun a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
单选题You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）A The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.B The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.D The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）A V$SYSSTATB V$SESSSTATC V$RSRC_PLAND V$RSRC_CONSUMER_GROUP
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT
单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A V$BACKUP_CORRUPTIONB V$COPY_CORRUPTIONC V$DATABASE_BLOCK_CORRUPTIOND RC_BACKUP_CORRUPTION