找考题网-背景图
单项选择题

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.

<上一题 目录 下一题>
热门试题

多项选择题WhichtwostatementsaretrueaboutBlockMediaRecovery（BMR）？（）

A. BMR increases the Mean Time To Recover （MTTR）.
B. BMR can only be implemented using Recovery Manager （RMAN）.
C. The blocks that need to be recovered are accessible during BMR.
D. BMR cannot be performed using cumulative incremental backups.
E. The datafile must be restored if most of the blocks in the datafile are corrupt.

单项选择题You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

A. by using the DBMS_REPAIR package
B. by using the DB_BLOCK_CHECKING parameter
C. by using the DBVERIFY utility
D. will not be completely resolved until the hardware fault is corrected

单项选择题You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

A.the alert log file and the trace files
B. the redo log files
C. the control file
D. the change tracking file

单项选择题YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis？（）

A. DBMS_REPAIR
B. DBMS_SCHDULER
C. DBMS_STATS
D. DBMS_RESOURCE_MANAGER

单项选择题You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01 oracle oradata data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

A. by using the DBMS_REPAIR package
B. by using the DBVERIFY utility
C. by using Block Media Recovery
D. by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command