多项选择题
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 -
单项选择题
WhichcommandisusedtoconfigureRMANtoperformacompressedbackupforeverybackupexecuted？（）
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
