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

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:  SQL> FLASHBACK TABLE ORDERS TO SCN 771513;   What is the prerequisite to perform Flashback Table?()

A You must configure OMF in your database.

B You must enable block change tracking feature in your database.

C You must enable ROW MOVEMENT feature on the ORDERS table.

D You must use the Flashback Version Query before using the Flashback Table feature.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

    答案解析

  • (多选题)

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

    答案解析

  • (多选题)

    You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()

    答案解析

  • (多选题)

    You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    答案解析

  • (多选题)

    You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()

    答案解析

  • (单选题)

    You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()

    答案解析

  • (单选题)

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    答案解析

  • (单选题)

    You are working on the Certkiller database.  What is the default name of the alert log file in this database?()

    答案解析

  • (多选题)

    You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()

    答案解析

  • (单选题)

    You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process?()

    答案解析

快考试在线搜题