READ Free Dumps For Oracle- 1z0-050
Question ID 6067 | Observe the following PL/SQL block: BEGIN dbms_spm .configure('SPACE_BUDGET_PERCENT', 30); END;Which statement is correct regarding the above PL/SQL block? |
Option A | It reserves 30% of the space in the SYSTEM tablespace for SMB. |
Option B | It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB). |
Option C | It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace. |
Option D | It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace. |
Correct Answer | c |
Question ID 6068 | Examine the following RMAN command: BACKUP DATABASE TAG TESTDB KEEP UNTIL 'SYSDATE+11 RESTORE POINT TESTDB06Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.); |
Option A | Only data files and the control file are backed up. |
Option B | Archived redo logs are backed up only if the database is open during the backup |
Option C | The backup is deleted after one day, regardless of the default retention policy settings |
Option D | The backup becomes obsolete after one day, regardless of the default retention policy settings. |
Correct Answer | B,D |