单项选择题
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.
相关考题
-
多项选择题
Whichoperationrequiresthatyoucreateanauxiliaryinstancemanuallybeforeexecutingtheoperation?()
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. -
多项选择题
Whenyoureperformingatablespacepoint-in-timerecovery,whichtablespaceswillalwaysberestoredtotheauxiliaryinstance?()
A. The SYSTEM tablespace.
B. The UNDO tablespace.
C. All tablespaces with tables.
D. All tablespaces with indexes.
E. No tablespaces are automatically restored. -
多项选择题
Whatarethetwodifferenttypesofdatabaseduplication?()
A. Active
B. Passive
C. Online
D. Backup-based
E. Failure driven
