Upgrade to Oracle Database 12c: 1Z0-060

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

B. All the user-defined tablespaces must be in read-only mode on the source database.

C. The export dump file must be created before starting the import on the target database.

D. The source and target database must be running on the same platform with the same endianness.

E. The path of data files on the target database must be the same as that on the source database.

F. The impdp operation must be performed by the same user that performed the expdp operation.

Which statement is true concerning dropping a pluggable database (PDB)?

A. The PDB must be open in read-only mode.

B. The PDB must be in mount state.

C. The PDB must be unplugged.

D. The PDB data files are always removed from disk.

E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

In your Oracle 12c database, you create two roles: AUDITOR and AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMIN role, you execute the following PL/SQL block:

Which statement is correct about the procedure?

A. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.

B. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT PAYABLE module is used.

C. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

D. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the ACCOUNT PAYABLE module is used.