单选题

On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct?() 

AYou can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.

BYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

DYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are managing an Oracle Database 11g database with this backup strategy:  - Every Sunday night, level 0 backup is performed.  - On Monday night and subsequent days, level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true()

    单选题查看答案

  • You are managing an Oracle Database 11g database with the following backup strategy:  1.On Sunday, an incremental level 0 tape backup is performed.  2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed.  Which two statements are true regarding the backups performed()

    多选题查看答案

  • You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this?()  

    单选题查看答案

  • You are working as a DBA in a company. The datafiles in the database are as follows:    On Monday, you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file?()

    单选题查看答案

  • You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands:   CONFIGURE DEFAULT DEVICE TYPE TO sbt;   CONFIGURE BACKUP OPTIMIZATION ON;   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   From Monday to Saturday, you performed the following actions:   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed?()

    单选题查看答案

  • Which two operations can be performed on an external table()

    多选题查看答案

  • Given: Which two, placed on line 13, will produce the output gobstopper?()

    多选题查看答案

  • You issue the following command:   RMAN>CONFIGURE BACKUP OPTIMIZATION ON;   What is the result of this command on your backups?()

    单选题查看答案

  • Given: Under which three circumstances will the code on line 37 be executed?()

    多选题查看答案