1Z1-060 Exam Question 61
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 62
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 63
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
1Z1-060 Exam Question 64
You created a new database using the "CREATE DATABASE" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE DATABASE" clause? (Choose two.)
What are two effects of not using the "ENABLE PLUGGABLE DATABASE" clause? (Choose two.)
1Z1-060 Exam Question 65
You use a recovery catalog for maintaining your database backups.
You execute the following command:

Which two statements are true? (Choose two.)
You execute the following command:

Which two statements are true? (Choose two.)