Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

1. A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file
2. B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
3. C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
4. D. The RMAN SHOW ALL command displays only settings with nondefault values.
5. E. A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
6. F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
7. G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Correct Answer: ABF

Which two are true about automatic block repair? (Choose two.)

1. A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
2. B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
3. C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
4. D. It is not possible for media corrupt blocks.
5. E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Correct Answer: BC

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

1. A. using Database Replay
2. B. using SQL Developer
3. C. using Oracle Data Pump
4. D. using operating system file copy utilities
5. E. using Database Upgrade Assistant
6. F. using the CREATE TABLE AS SELECT SQLstatement

Correct Answer: DEF

Which three are located by using environment variables? (Choose three.)

1. A. the Optimal Flexible Architecture (OFA) compliant path to storeOracle software and configuration files.
2. B. the location of Oracle Net Services configuration files
3. C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
4. D. default directories for temporary files used by temporary tablespaces
5. E. the temporary disk space used by Oracle Installer during installation
6. F. the maximum number of database files that can be opened by a database instance

Correct Answer: ABE

Which two are true about instance recovery? (Choose two.)

1. A. It is not possible if an archived log is missing.
2. B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
3. C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
4. D. It is performed by the Recovery Writer (RVWR) background process.
5. E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time bycausing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
6. F. It is performed automatically while the database remains in MOUNT stat
7. G. Then the database is opened.

Correct Answer: EF