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.
  • 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?
  • 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.)
  • 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?
  • 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?