A. set Flash Recovery Area
B. enable Flashback logging
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode
E. start the database in the NOARCHIVELOG mode

A. Drop User
B. Tablespace Space Usage
C. Resumable Session Suspended
D. Recovery Area Low On Free Space
E. SYSTEM Tablespace Size Increment

A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

A. It is built by Automatic Tuning Optimizer.
B. It cannot be stored persistently in the data dictionary.
C. It can be used by the query optimizer automatically.
D. It can be created manually by using the CREATE PROFILE command.

A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
C.  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

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.

A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management

A. CKPT
B. SMON
C. MMON
D. DBWR

A. Define the POWER option while adding or removing the disks
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

A. You are backing up to tape and your tape device performs its own compression.
B. You are making image copies, and you have not enabled tablespace compression.
C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.