1Z1-060 Exam Question 81

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
  • 1Z1-060 Exam Question 82

    You are connected to a pluggable database (PDB) as a common user with DBA privileges.
    The STATISTICS_LEVELparameter is PDB_MODIFIABLE. You execute the following:
    SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE; Which is true about the result of this command?
  • 1Z1-060 Exam Question 83

    You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
    You issue the following statements:
    SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
    SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
    SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
    For which database users is the audit policy now active?
  • 1Z1-060 Exam Question 84

    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
    The characteristics of the non-CDB are as follows:
    * Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
    * Character Set: AL32UTF8
    * National Character Set: AL16UTF16
    * O/S: Oracle Linux 6 64-bit
    The characteristics of the CDB are as follows:
    * Version: Oracle Database 12c Release 1 64-bit
    * Character Set: AL32UTF8
    * National Character Set: AL16UTF16
    * O/S: Oracle Linux 6 64-bit
    Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
  • 1Z1-060 Exam Question 85

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?