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