网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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$WAITS
D
V$WAITSTAT
E
V$SESSION_LONGOPS
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
Whatviewmightyouusetotrytodeterminehowlongaparticularbackupwilltake?()
A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SESSION_LONGOPS
考题
Inwhatviewareyoulikelytoseethefollowingoutput?()SIDSERIALEVENTSECONDS_IN_WAIT121269RMANbackuprecoveryI／O2129415SQL*Netmessagefromclient63130270SQL*Netmessagefromclient
A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SYSSTAT
考题
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
考题
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
考题
You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE、run 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
考题
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？（）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.
考题
单选题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
考题
单选题You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A
Create a backup of the database and recover all corrupted blocks found in the backup.B
Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C
Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D
Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E
Run 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.
考题
单选题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_STATUSC
V$BACKUP_DATAFILED
V$DATAFILE_BACKUPE
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
考题
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A
create a backup of the database and recover all corrupted blocks found in the backupB
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE
run 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
热门标签
最新试卷
