Your DB_RECOVERY_FILE_DEST_SIZE is 8G.
Currently, 5G of the space is used of which 4G consists of obsolete backups.
You execute this command:
SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;
What is the outcome?
A. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups.
B. It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.
C. It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter.
D. It fails because the new size is less than 5G.
E. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.
|
Download Printable PDF. VALID exam to help you PASS. |
 |