单项选择题
A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B. Capture the plans from the previous version using STS and then load them into the stored outline.
C. Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
单项选择题 A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK /devices/diska1, /devices/diska2 FAILGROUP controller2 DISK /devices/diskb1, /devices/diskb2 ; What happens when the whole CONTROLLER1 Failure group is damaged?（）
多项选择题 The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct? （）(Choose two.)
多项选择题 WhatrecommendationsdoestheSQLAccessAdvisorprovideforoptimizingSQLqueries？（）