多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:A,C
答案解析:
进入题库查看解析

微信扫一扫手机做题