A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. Th……

单项选择题Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

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

单项选择题Which of the following advisors is run in every maintenance window by the auto-task system?（）

A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor

单项选择题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor

单项选择题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor

多项选择题Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)

A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor