Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)
SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT;BLOCKS -----------------704SQL> ALTER TABLE altb SHRINK SPACE COMPACT;Table altered.SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;BLOCKS --------------------------704View the Exhibit and examine the output and commands executed on the ALTB table.Why does the number of blocks for the table remain the same after the shrink operation?
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?
Identify two correct statements about the Active Session History (ASH) data.
Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).
