單項選擇題

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

你可能感興趣的試題

單項選擇題

You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use？（）

A. FILE
B. PARFILE
C. LOGFILE
D. FEEDBACK

單項選擇題

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

A. Block Media Recovery must be used with RMAN.
B. You must perform complete recovery of individual blocks.
C. You must have a full RMAN backup， not an incremental backup.
D. You must use the DBVERIFY utility before using the Block Media Recovery feature.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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

你可能感興趣的試題

You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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