单项选择题

Which statement is true regarding the VALIDATE DATABASE command？（）

A. It checks the database for intrablock corruptions only.
B. It checks for block corruption in the valid backups of the database.
C. It checks the database for both intrablock and interblock corruptions.
D. It checks for only those corrupted blocks that are associated with data files.

<上一题目录下一题>

热门试题

单项选择题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?（）

A. only the control file, the current SPFILE, and data files
B. only the current SPFILE and data files if autobackup is disabled
C. only the data files and the archived redo logs
D. the control file, current SPFILE file, data files, and archived redo logs

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