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?

• A.All users except SYS
• B.All users except SCOTT
• C.All users except sys and SCOTT
• D.All users except sys, system, and SCOTT

Comment: *

Name: *

Email: *

Verification: *

You want to create a role that:
-is protected from unauthorized usage
-does not use a password embedded in the application source code or stored in a table
-is enabled for a user based on security policies defined in a PL/SQL package
How would you create this role?

• A.as a secure application role
• B.with definer's rights
• C.with global authentication
• D.with external authentication

Comment: *

Name: *

Email: *

Verification: *

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

• A.Parallel compilation of only the stored PL/SQL code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel recompilation of any stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Sequential recompilation of Java code

Comment: *

Name: *

Email: *

Verification: *

What must you use to read data from a table in your database and write it to an external table?

• A.Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.
• B.Use SQL* LOADER direct path load.
• C.Use SQL* LOADER conventional path load.
• D.Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• B.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C.BACKUP DATABASE while connected to the PDB1 container
• D.BACKUP DATABASE while connected to the boot container
• E.BACKUP PLUGGABLE database PDB1 while connected to PDB2

Comment: *

Name: *

Email: *

Verification: *