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?
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?
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?
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?
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?