Your container database, CDB1 has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT Which two are always true?

• A.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• B.Cloning HR_ROOT automatically clones HR_PDB1.
• C.The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• D.CDB1 and CDB2 must be In shared undo mode.
• E.A common user must exist in CDB2 with the create pluggable database privilege.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR)?

• A.The taking of AWR snapshots can be disabled.
• B.AWR data is stored in the system tablespace.
• C.By default, AWR snapshots are taken every 60 minutes.
• D.Its collection level is determined by the value of the statistics_level database parameter.
• E.By default, AWR snapshots are retained for 7 days.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

• A.creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
• B.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• C.creating a new empty PDB in the local database from PDB$SEED
• D.creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
• E.automatically dropping the database link to the remote database if it already exists
• F.opening the cloned PDB
• G.creating a database link from CDB$ROOT in the remote database to the PDB in the local database

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?

• A.It can be launched from both the command line and the Universal Installer (OUI) interfaces.
• B.It can be used to create container databases and non-container databases.
• C.It can only be launched from the command line interface.
• D.It can be used to convert a non-container database to a container database.
• E.It can be used to change the character set of an existing database.

Comment: *

Name: *

Email: *

Verification: *

RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

• A.RMAN uses the pull method to restore files using backup sets
• B.RMAN uses the pull method to restore files using image copies
• C.RMAN uses the push method to transfer backup sets
• D.RMAN uses the push method to transfer image copies

Comment: *

Name: *

Email: *

Verification: *