多项选择题

In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations

点击查看答案

上一题目录下一题

相关考题

单项选择题

You issue the following command：
RMAN>CONFIGURE BACKUP OPTIMIZATION ON；
What is the result of this command on your backups？（）

A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E. RMAN will automatically compress backups.

单项选择题

Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）

A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor

单项选择题

Which command is used to configure RMAN to perform a compressed backup for every backup executed？（）

A. BACKUP AS COMPRESSED BACKUPSET DATABASE
B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
E. BACKUP DATABASE COMPRESS