niusouti.com

单选题The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement 

题目
单选题
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）
A

The statistics collection continues until all objects are processed.

B

The job is terminated and the statistics collected are restored to a time before the job started.

C

This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

D

The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

相似考题

1.The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A. statistics recommendationsB. SQL Profile recommendationsC. Index-related recommendationsD. restructuring of SQL recommendations

2.You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Decrease the expiration time for the baseline.

3.You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

4.Which tasks are run automatically as part of the Automated Maintenance Task by default?()A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor

更多“单选题The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement ”相关问题

  • 第1题：

    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


    参考答案：A, C, D

  • 第2题：

    In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）

    • A、Window
    • B、Program
    • C、Job class
    • D、Window group

    正确答案:B

  • 第3题：

    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

    正确答案:A,C,D

  • 第4题：

    Which setting enables the baselines by default in Oracle Database 11g？（）  

    • A、 setting the STATISTICS_LEVEL parameter to TYPICAL
    • B、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）
    • C、 enabling Automated Maintenance Task using Oracle Enterprise Manager
    • D、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

    正确答案:A

  • 第5题：

    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

    • A、 The statistics are stored in the pending statistics table in the data dictionary.
    • B、 The statistics are treated as the current statistics by the optimizer for all sessions.
    • C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
    • D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

    正确答案:A

  • 第6题：

    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）

    • A、The statistics collection continues until all objects are processed.
    • B、The job is terminated and the statistics collected are restored to a time before the job started.
    • C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
    • D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

    正确答案:D

  • 第7题：

    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）

    • A、The statistics collection continues until all objects are processed.
    • B、The job is terminated and the statistics collected are restored to a time before the job started.
    • C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
    • D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.

    正确答案:D

  • 第8题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    Which three statements are true about SQL plan directives?（）
    A

    They are tied to a specific statement or SQL id.

    B

    They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

    C

    They are used to gather only missing statistics.

    D

    They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

    E

    They instruct the optimizer to create only column group statistics.

    F

    Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.


    正确答案： B,D,E
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements are true with respect to the maintenance window？（） .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


    正确答案： B,A
    解析： 暂无解析

  • 第11题：

    单选题
    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）
    A

    Compute the baseline statistics.

    B

    Take an immediate AWR snapshot.

    C

    Decrease the window size for the baseline.

    D

    Decrease the expiration time for the baseline.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）
    A

     statistics recommendations

    B

     SQL Profile recommendations

    C

     Index-related recommendations

    D

     restructuring of SQL recommendations


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Which three statements are true about SQL plan directives?()

    A. They are tied to a specific statement or SQL id.

    B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

    C. They are used to gather only missing statistics.

    D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

    E. They instruct the optimizer to create only column group statistics.

    F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.


    参考答案：B, D, E

  • 第14题：

    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）

    • A、Compute the baseline statistics.
    • B、Take an immediate AWR snapshot.
    • C、Decrease the window size for the baseline.
    • D、Decrease the expiration time for the baseline.

    正确答案:A

  • 第15题：

    Which two statements are true with respect to the maintenance window？（） .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第16题：

    The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

    • A、statistics recommendations
    • B、SQL Profile recommendations
    • C、Index-related recommendations
    • D、restructuring of SQL recommendations

    正确答案:B

  • 第17题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default？（） 

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

    正确答案:A,C,D

  • 第18题：

    Which two statements are true with respect to the maintenance window? （）

    • A、A DBA can enable or disable an individual task in all maintenance windows.
    • B、A DBA cannot change the duration of the maintenance window after it is created.
    • C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
    • D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

    正确答案:A,D

  • 第19题：

    单选题
    Which setting enables the baselines by default in Oracle Database 11g？（）
    A

     setting the STATISTICS_LEVEL parameter to TYPICAL

    B

     adding filters to the Automatic Database Diagnostic Monitor （ADDM）

    C

     enabling Automated Maintenance Task using Oracle Enterprise Manager

    D

     setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Which setting enables the baselines by default in Oracle Database 11g?（）
    A

    setting the STATISTICS_LEVEL parameter to TYPICAL

    B

    adding filters to the Automatic Database Diagnostic Monitor (ADDM)

    C

    enabling Automated Maintenance Task using Oracle Enterprise Manager

    D

    setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）
    A

    The statistics are stored in the pending statistics table in the data dictionary.

    B

    The statistics are treated as the current statistics by the optimizer for all sessions.

    C

    The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D

    The statistics are temporary and used by the optimizer for all sessions until this session terminates.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）
    A

     Compute the baseline statistics.

    B

     Take an immediate AWR snapshot.

    C

     Decrease the window size for the baseline.

    D

     Decrease the expiration time for the baseline.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）
    A

     The statistics are stored in the pending statistics table in the data dictionary.

    B

     The statistics are treated as the current statistics by the optimizer for all sessions.

    C

     The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D

     The statistics are temporary and used by the optimizer for all sessions until this session terminates.


    正确答案： D
    解析： 暂无解析

相关内容