You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

• A. SYS, SYSTEM
• B. Only for failed executions
• C. Only for successful executions
• D. SCOTT
• E. Both successful and failed executions

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• B. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
• C. It fails and reports an error because the CONTAINER=ALL clause is not used.
• D. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

• A. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set
• B. alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set
• C. alphanumeric columns that need no conversion
• D. numeric columns that will exceed the column size limit after converting to the chosen Unicode character set
• E. date columns that will have invalid binary representation after converting to the chosen Unicode character set
• F. numeric columns that will have invalid binary representation after converting to the chosen Unicode character set

Which three statements are true about adaptive SQL plan management?

• A. It adds new, bettor plans automatically as fixed plans to the baseline.
• B. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• C. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
• D. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• E. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

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

• A. It will create a CDB with root and seed opened and one PDB mounted.
• B. It will create a CDB with root opened and seed mounted.
• C. It will create a CDB with root opened and seed read only.
• D. It will create a CDB that must be plugged into an existing CDB.
• E. It will create a multitenant container database (CDB) with only the root opened.