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.
正确答案
答案解析
相似试题
(多选题)
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()