Flashback Database recovery can recover from which of the following failure scenarios?
Loss of control file
Dropping a tablespace through RESETLOGS
A user error that resized datafiles to a smaller size
A large truncated table or group of tables
What new background process is responsible for writing before block images and recovering from the Flashback Database log?
RWVR
RVWR
RWRV
RVRW
What are the benefits of the flash recovery area in the recovery and backup process?
Recovery efficiency is improved because all files are stored on tape media for fast access.
Recovery efficiency is improved because the files are stored in multiple locations.
Recovery efficiency is improved because the files are stored in one location on tape.
Recovery efficiency is improved because the files are stored in one location on disk.
Where is information about the status of the flash recovery area displayed? (Choose all that apply.)
Alert log
Background trace files
V$_OUSTANDING_ALERTS
DBA_OUTSTANDING_ALERTS
How is the size of the flash recovery area determined? (Choose all that apply.)
The size is automatically allocated at 2 gigabytes.
Using the ALTER SYSTEM command to dynamically set the size.
With the initialization parameter DB_RECOVERY_FILE_DEST_SIZE.
Using the ALTER TABLESPACE command.
What type of backup commands can the flash recovery area be used for? (Choose all that apply.)
BACKUP COPY
BACKUP IMAGE
BACKUP
BACKUPSET
The flash recovery area space utilization and stored files can be identified by what method?
DBA_OUTSTANDING_ALERTS
V$OUTSTANDING_ALERTS
V$RECOVERY_FILE_DEST
DBA_RECOVERY_FILE_DEST
What parameter determines the length of time that the Flashback Database will store "before" images that can be used in the recovery process?
DB_FLASHBACK_RETENTION_POLICY
DB_FLASHBACK_RETENTION_TIME
DB_FLASHBACK_RETENTION_STORE
DB_FLASHBACK_RETENTION_TARGET
How is the DB_FLASHBACK_RETENTION_TARGET parameter measured?
By SCN
By redo log sequences
By time in minutes
By redo log sequence and threads
To enable the Flashback Database, what must be done to the database? (Choose all that apply.)
It must be mounted.
It must be opened with RESETLOGS.
The flash recovery area must be created.
The database must be in ARCHIVELOG mode.
When using the Flashback Database in a recovery situation, what information would be useful to know? (Choose all that apply.)
Information about the smallest SCN number that is stored in the Flashback Database log
Information about the earliest timestamp that is stored in the Flashback Database log
Information about the greatest SCN number that is stored in the Flashback Database log
Information about the latest timestamp that is stored in the Flashback Database log
Which of the following views can determine how much space you may need in the future in the Flashback Database logs?
V$DATABASE
V$FLASHBACK_DATABASE_STAT
V$FLASHBCK_DATABASE_LOG
DBA_FLASHBACK_LOG
What is the default size of a redo log file created in the flash recovery area?
100MB
150MB
10MB
50MB
Which initialization parameter will create archive logs to the flash recovery area?
ARCHIVE_LO6_DEST
ARCHIVE_DUPLEX_DEST
ARCHIVE_LOG_DEST_ n
LOG_ARCHIVE_DEST_n
Which database files are permanently stored in the flash recovery area? (Choose all that apply.)
Datafiles
RMAN files
Control files
Current online redo logs
Archive logs
Which files will not be backed up in the flash recovery area when you're using the BACKUP RECOVERY AREA and BACKUP RECOVERY FILES commands? (Choose all that apply.)
Control files
Redo logs
Datafiles
Permanent files
Flashback logs
What is responsible for applying the "before" images to the database during a Flashback Database recovery?
LGWR
SMON
DBWR
RVWR
What administrative database activity cannot be undone with the Flashback Database recovery?
Dropped table
Dropped user
Resized datafiles to smaller size
Dropped tablespace