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
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
相关考题：
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
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
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
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.
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.
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.) A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
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.
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、WindowB、ProgramC、Job classD、Window group
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.
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)A、Segment AdvisorB、SQL Access AdvisorC、Optimizer statistics gatheringD、Automatic SQL Tuning AdvisorE、Automatic Database Diagnostics Monitor
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
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
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
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.
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
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.
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、 WindowB、 ProgramC、 Job classD、 Window group
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.
单选题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
单选题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（）AThe statistics collection continues until all objects are processed.BThe job is terminated and the statistics collected are restored to a time before the job started.CThis produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.DThe job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.
多选题Which three statements are true about SQL plan directives?（）AThey are tied to a specific statement or SQL id.BThey instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.CThey are used to gather only missing statistics.DThey are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.EThey instruct the optimizer to create only column group statistics.FImprove plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
单选题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 WindowB ProgramC Job classD Window group
单选题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（）AThe statistics collection continues until all objects are processed.BThe job is terminated and the statistics collected are restored to a time before the job started.CThis produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.DThe job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
单选题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.
单选题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
单选题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.