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
正确答案
答案解析
相似试题
(单选题)
In which scenario, will you issue the following command?() RMAN> REPORT NEED BACKUP DAYS 7;
(单选题)
You issue these LSNRCTL commands: LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands?()
(单选题)
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
(单选题)
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
(单选题)
You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command?()
(单选题)
You issued the following command at the UNIX environment: % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command?()
(多选题)
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
(单选题)
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day,you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()
(单选题)
You issued the RMAN>SHOW ALL; command. The output of this command is as follows: After analyzing the output, which conclusion will you draw?()
(单选题)
You issued the RMAN> SHOW ALL; command. The output of this command is as follows: After analyzing the output, which conclusion will you draw?()