多项选择题

In which scenarios would you rebuild an index？（）

A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）

A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days

单项选择题

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

A. create a hash cluster to store the data
B. create an index cluster to store the data
C. create a partitioned table to store the data
D. create a sorted hash cluster to store the data
E. create a heap table with rowid to store the data

单项选择题

While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）

A. Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
B. Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
C. Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
D. Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.