You issued the following command to analyze the SCOTT.E

单项选择题

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？（）

单项选择题 YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis？（）

单项选择题 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）？（）

1z0-043