Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

单项选择题WhichstatementaboutAutomaticMemoryManagementwithOracle11gistrue？（）

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.

单项选择题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B. RMAN reads the block change tracking file when it performs both incremental backups.
C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D. RMAN does not read the block change tracking file when it performs either incremental backup.

单项选择题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?（）

A. standard backup set
B. image copy
C. compressed backup
D. user-managed backup

多项选择题WhichthreestatementsaboutperformanceanalysisbySQLPerformanceAnalyzeraretrue？（）

A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.

单项选择题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING