（单选题）
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
正确答案
答案解析
略
相似试题
（单选题）
Which statement is true while creating subplans using Resource Manager？（）
（单选题）
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?（）
（单选题）
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?（）
（单选题）
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?（）
（单选题）
While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）
（多选题）
Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）
（单选题）
You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
（多选题）
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
（单选题）
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）
