多选题

Which two statements are correct regarding the Oracle Flashback Drop feature? ()

A Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.

B You can flash back a dropped table provided row movement has been enabled on the table.

C If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.

D When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.

E When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.

F If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

正确答案

来源:www.examk.com

答案解析

相似试题
  • Which two statements are true about Oracle Real Applications Insight ?()

    多选题查看答案

  • Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file?()

    多选题查看答案

  • Which two statements are true?()

    多选题查看答案

  • Which two operations require undo data?()

    多选题查看答案

  • Which two statements are true about alerts()

    多选题查看答案

  • Which two triggers are mouse movement triggers?()

    多选题查看答案

  • Which two statements are true regarding listeners()

    多选题查看答案

  • Which two statements are true regarding views?()

    多选题查看答案

  • Which two statements are true about checkpointing()

    多选题查看答案