单选题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
单选题
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
参考解析
解析：
暂无解析
相关考题：
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 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
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 statisticsB、It makes the statistics information available to GATHER_STATS_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually
Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）A、Automatic statistics collection is stopped for the CUSTOMERS table.B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）A、Average row sizeB、Last analyzed dateC、Size of table in bytesD、Size of table in database blocksE、Number of free blocks in the free listF、Number of extents present in the table.
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）A、The optimizer statistics are collected automatically.B、Only the timed operating system （OS） statistics and plan execution statistics are collected.C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
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.
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
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.B、The optimizer can re optimize a query only once using cardinality feedback.C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.
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_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
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
Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A、Automatic statistics collection is stopped for the CUSTOMERS table.B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
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.
多选题You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）Aaverage row sizeBlast analyzed dateCsize of table in bytesDsize of table in database blocksEnumber of free blocks in the free listFnumber of extents present in the table
单选题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.
单选题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？（）AWindowBProgramCJob classDWindow group
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
多选题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.
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
单选题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?（）AIt updates the existing SQL profiles with current statistics.BIt makes the statistics information available to GATHER_STATS_JOBCIt initiates the statistics collection process by running GATHER_STATS_JOBDIt logs a warning message in the alert log so that the DBA can perform statistics collection manually.
单选题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.
单选题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
单选题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 statisticsB It makes the statistics information available to GATHER_STATS_JOBC It initiates the statistics collection process by running GATHER_STATS_JOBD It logs a warning message in the alert log so that the DBA can perform statistics collection manually
多选题Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）AThe optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.BThe optimizer can re optimize a query only once using cardinality feedback.CThe optimizer enables monitoring for cardinality feedback after the first execution of a query.DThe optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.EAfter the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.