单项选择题

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