首页计算机考试Oracle认证
(单选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

快考试在线搜题