单选题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 

题目
单选题
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.

相似考题

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.Which setting enables the baselines by default in Oracle Database 11g?()A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

3.The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()A. to prevent the creation of an excessive number of scheduler job classesB. to allow the Automated Maintenance Tasks to use system resources without any restrictionC. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

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 inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for 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题：

    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）

    • A、to prevent the creation of an excessive number of scheduler job classes
    • B、to allow the Automated Maintenance Tasks to use system resources without any restriction
    • C、to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
    • D、to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

    正确答案: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题：

    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

  • 第6题：

    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

  • 第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题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. 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


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

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第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题：

    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

  • 第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题：

    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

  • 第18题：

    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. 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

  • 第19题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

    • A、You should create a job which is assigned to the Database Maintenance category
    • B、You should create an Alert which will run another to delete the maintenance job.
    • C、You should create a job. You schedule the job to run only once.
    • D、You should create a job. The job uses the Automatically delete job option

    正确答案:D

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）
    A

    You should create a job which is assigned to the Database Maintenance category

    B

    You should create an Alert which will run another to delete the maintenance job.

    C

    You should create a job. You schedule the job to run only once.

    D

    You should create a job. The job uses the Automatically delete job option


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

  • 第22题：

    单选题
    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）
    A

    to prevent the creation of an excessive number of scheduler job classes

    B

    to allow the Automated Maintenance Tasks to use system resources without any restriction

    C

    to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

    D

    to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容