单项选择题
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）
A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor
点击查看答案
相关考题
-
单项选择题
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
