多項(xiàng)選擇題

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.

題目列表

你可能感興趣的試題

多項(xiàng)選擇題

These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT 
Name                    Null?              Type 
------------- -------- -------------- 
BEGIN_TIME                               DATE 
END_TIME                                 DATE 
FLASHBACK_DATA                        NUMBER 
DB_DATA                                  NUMBER 
REDO_DATA                               NUMBER 
ESTIMATED_FLASHBACK_SIZE             NUMBER 
Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()

A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

微信掃碼免費(fèi)搜題