单选题

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

正确答案

来源:www.examk.com

答案解析

相似试题
  • 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)?()  

    单选题查看答案