16. The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following
command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A. a list of all the expired backups and copies
B. a list of all those files that have been deleted in the last two days
C. a […]

11. Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to
use Recovery Manager (RMAN) to perform backups.
Which two backups would you be able to perform when the database is being accessed by users? (Choose two.)
A. backup of offline tablespaces
B. backup of read-only tablespaces
C. backup of system-critical tablespaces
D. backup of online, […]

6. In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is
set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery
Manager (RMAN)?
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for […]

1. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to
YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer:BE
2. The database is running in ARCHIVELOG mode and the […]