多项选择题

What is the purpose of the RMAN recovery catalog？（）

A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.
B. It provides a convenient， optional， repository of backup- and recovery-related metadata.
C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
D. It provides a means of storing all RMAN backup sets physically in an Oracle database server.
E. It provides the ability to store backup records for more than a year.

<上一题目录下一题>

热门试题

多项选择题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

单项选择题Which statement about Automatic Memory Management with Oracle 11g is true?（）

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size