多项选择题
Which two statements regarding the Flashback Table feature are correct？（）
A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D. Flashback Table operation acquires exclusive data manipulation language （DML） locks.
相关考题
-
多项选择题
Which two client requests are captured during database replay Capture?（） (Choose two)
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations -
单项选择题
You issued the following command on the temporary tablespace LMTEMP in your database： SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）
A. The tablespace must be locally managed.
B. The tablespace must have only one temp file.
C. The tablespace must be made nondefault and offline.
D. The tablespace can remain as the default but must have no active sort operations. -
多项选择题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data
