多项选择题

What are the prerequisites for performing flashback transactions? （）(Choose all that apply)

A. Supplemental log must be enabled
B. Supplemental log must be enabled for the primary key
C. Undo retention guarantee for the database must be configured
D. ”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user

点击查看答案

上一题目录下一题

相关考题

单项选择题

Examine the following PL/SQL block：
SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；
BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；
DBMS_OUTPUT.PUT_LINE（report）；
END；
Which statement describes the effect of the execution of the above PL/SQL block？（）

A. The plan baselines are verified with the SQL profiles.
B. All fixed plan baselines are converted into nonfixed plan baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

多项选择题

Which operation requires that you create an auxiliary instance manually before executing the operation？（）

A. Backup-based database duplication.
B. Active database duplication.
C. Tablespace point-in-time recovery.
D. No operation requires the creation of an auxiliary instance.

多项选择题

When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）

A. The SYSTEM tablespace.
B. The UNDO tablespace.
C. All tablespaces with tables.
D. All tablespaces with indexes.
E. No tablespaces are automatically restored.