Question 1
One of your databases runs in ARCHIVELOG mode.
Examine this command:

Now examine these steps executed from RMAN:
1) SHUTDOWN IMMEDIATE
2) STARTUP MOUNT
3) BACKUP DATABASE;
4) BACKUP ARCHIVELOG ALL;
5) ALTER DATABASE OPEN;
6) STARTUP
Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.
Examine this command:

Now examine these steps executed from RMAN:
1) SHUTDOWN IMMEDIATE
2) STARTUP MOUNT
3) BACKUP DATABASE;
4) BACKUP ARCHIVELOG ALL;
5) ALTER DATABASE OPEN;
6) STARTUP
Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.
Question 2
A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

All users have their default set of system privileges.
For which three situations will data not be redacted?
Question 3
Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output? (Choose three.)

Which three statements are true about the users (other than sys) in the output? (Choose three.)
Question 4
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

Which two statements are true about redefining the table?
Question 5
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?