单选题 While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
Block Media Recovery must be used with RMAN.
You must perform complete recovery of individual blocks.
You must have a full RMAN backup， not an incremental backup.
You must use the DBVERIFY utility before using the Block Media Recovery feature.
单选题 You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）
configure a default device for RMAN backups
temporarily disable the retention policy for RMAN backups
configure automatic channel allocation for RMAN backups
use the CONFIGURE command to reconfigure the recovery window to 60 days
单选题 You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）
单选题 You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）
单选题 While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
It would result in an error because the warning threshold cannot be more than the critical threshold.
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
单选题 You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）
This instance is being used to manage the operating system files.
This instance is being used to manage the files of other databases.
This instance is being used to manage the instances of other databases.
This instance is being used to manage the background processes of other instances.
多选题 You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）
control file autobackups
copies of all the parameter files
trace file generated using BACKUP CONTROLFILE TO TRACE
单选题 You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
SQL Access Advisor
SQL Tuning Advisor
单选题 You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）
The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
多选题 Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）
You find that one of the redo log members in each redo log group is lost.
You find that a data file that belongs to the USERS tablespace is damaged.
You find that a data file that belongs to the SYSTEM tablespace is damaged.
You find that the current redo log group is damaged and is not available for recovery.
You realized while performing a recovery that an archived redo log file needed for recovery is lost.