What happens if you shutdown abort ASM instance?（）

单项选择题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

A. It updates the existing SQL profiles with current statistics.
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

单项选择题You need to restore your database back to 9 30 2008 at 18：00. In what order would you run the following commands to compete this task？（）   a. restore controlfile until time `09 30 2008：18：00：00’ b. restore database until time `09 30 2008：18：00：00’  c. restore spfile until time `09 30 2008：18：00：00’ d. recover database until time `09 30 2008：18：00：00’ e. alter database open resetlogs f. alter database open

A. b， d， e
B. b， d， f
C. c， a， b， d， e
D. c， a， b， d， f
E. a， b， d， e

多项选择题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

多项选择题When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)

A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.

单项选择题To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）

A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
D. Either B or C
E. All of the above