Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

• A.A base recovery catalog should exist.
• B.The owner of VPC cannot own recovery catalog.
• C.The recovery_catalog_owner role should be granted to the virtual catalog owner.
• D.The register database privilege should be granted to the virtual catalog owner.
• E.At least one target database should be registered in the recovery catalog.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

• A.CDB$ROOT is in MOUNT state.
• B.PDB1 and PDB2 are in MOUNT state.
• C.PDB$SEED is in READ ONLY state.
• D.Redo logs are opened.
• E.PDB1 and PDB2 are in READ ONLY state.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database link in CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute these commands successfully: $ sqlplus sys/oracle_4U@cdb2 as sysdba SQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT= ('PDB1_C1_SRV', 'PDB1_C2_SRV') ; Which two are true?

• A.PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
• B.PDB1_C2_SRV will be created and started automatically.
• C.PDB1_C2_SRV will be created but not started.
• D.PDB1 will be created in CDB2 and left in MOUNT state.
• E.PDB1 will be created in CDB2 and automatically opened.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

• A.The database must be opened in read-only mode.
• B.The Pre-Upgrade Information Tool script is executed by DBUA.
• C.A whole database backup must exist before upgrade
• D.DBUA must be launched from the target Oracle Home.
• E.Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
• F.All pluggable databases are automatically upgraded as part of a container database upgrade.

Comment: *

Name: *

Email: *

Verification: *

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

• A.It fails because system privileges cannot be granted with roles in the same audit policy.
• B.It fails because the command does notspecify when the unified audit policy should be enforced.
• C.It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
• D.It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

Comment: *

Name: *

Email: *

Verification: *