YouwanttochecktheEMPtableintheuser，Scott’sschemaforblockcorruption.Youalsowanttofixthecorruptedblocks，ifany.Howwillyouaccomplishtherequiredtask？（）A.by using the ANALYZE utilityB.by using the DBVERIFY utilityC.by using the DB_BLOCK_CHECKING parameterD.by using the DBMS_REPAIR package

单项选择题

You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

A.by using the ANALYZE utility
B.by using the DBVERIFY utility
C.by using the DB_BLOCK_CHECKING parameter
D.by using the DBMS_REPAIR package

相关考题

单项选择题 YouareusingtheDBVERIFYutilitytocheckthedatafilesforanyblockcorruption.Youwanttowritetheoutputofthedbvcommandtoafilenottothescreen.WhichparameteroftheDBVERIFYutilitywillyouuse？（）

单项选择题 While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

单项选择题 You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1z0-043