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, […]

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 […]