（单选题）
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
正确答案
答案解析
略
相似试题
（单选题）
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs？（）
（单选题）
Exhibit： Using Database Control， you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
（单选题）
You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change？（）
（单选题）
View the Exhibit and examine the properties of the TT tablespace. Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
（单选题）
View the Exhibit and examine the properties of the TT tablespace. Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday. When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
（单选题）
View the Exhibit to observe the roles assigned to the SLP_REP user. Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）
（单选题）
You are creating a job class. You have issued the following command to create the job class： SQL> BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS（ JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’， RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’， LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL， LOG_HISTORY => 1200， COMMENTS => ’LOW JOB PRIORITY CLASS’）； END； SQL> / What will be the result of the above command？（）
（单选题）
You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）
（单选题）
You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）
（单选题）
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）
