多項選擇題

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.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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

你可能感興趣的試題

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？（）

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

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？（）

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