网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
A
recover lost blocks
B
recover corrupt blocks
C
recover media corrupt blocks from list
D
recover corrupt blocks from list
E
recover corruption list
参考答案
参考解析
解析：
暂无解析
更多 “单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list” 相关考题
考题
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
考题
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
考题
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
考题
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A、V_CONTROLFILE_RECORD_SECTION B、V_CONTROLFILE C、V$PARAMETER D、init.ora file
考题
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
考题
Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A、V$LOGB、V$LOFHISTC、V$LOGFILED、V$LOG_HISTORY
考题
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
考题
You need to use the Event Viewer window to review the event logs for only critical and error events. You also need the maximum amount of detail for each of these events. What should you do？ （）A、Edit the filter for the Administrative Events view.B、Create a custom view. Enable the Critical， Error， and Information level events. Select all logs.C、Create a custom view. Select the Critical checkbox， Error checkbox， and Verbose checkbox. Select all logs.D、Search for the Critical or Error string by using the Find option of the Administrative Events view.
考题
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（） A、 Use a Dynamic Management View to check for locks.B、 Use a Dynamic Management View to check for blocked queries.C、 Use a Dynamic Management View to check for long-running queries.D、 Use a Dynamic Management View to check the size and maximum size of the database.
考题
You are an Administrator at Cer-tech .com. you manage a member server that runs Windows Server 2008.The Terminal Server Gateway （TS Gateway） is also installed on the member server. You want to find outwhether a group of users have ever connected to their workstations remotely through TS Gateway server. What should you do to achieve this task？（）A、Open the TS gateway console and view the events in the monitoring fieldB、View the Windows Server 2008 Event Viewer for TS Gateway connectionsC、View Event Viewer security logD、View the Event Viewer Terminal Services-gateway log
考题
单选题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 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 want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A
DBA_SCHEDULER_JOB_RUN_DETAILSB
DBA_SCHEDULER_RUNNING_JOBSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
单选题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_EVENTB
V$SESSIONC
V$WAITSD
V$WAITSTATE
V$SESSION_LONGOPS
考题
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A
V$LOGB
V$LOGFILEC
DBA_LOG_GROUPSD
V$LOG_HISTORY
考题
单选题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
考题
单选题W are sure that you will find a ready sale ____ this type of new product.A
toB
forC
onD
in
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题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
考题
单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A
recover lost blocksB
recover corrupt blocksC
recover media corrupt blocks from listD
recover corrupt blocks from listE
recover corruption list
考题
单选题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 are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
热门标签
最新试卷