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

• A.leaving the cloned PDB in mount state
• B.opening the cloned PDB
• C.backing up the cloned PDB
• D.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• E.creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A.V$SESSION_EVENT
• B.V$SESSION
• C.V$SESSTAT
• D.V$SESSION_WAIT
• E.V$SESSION_WAIT_CLASS

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

• A.A target database's persistent RMAN configuration settings are always stored in the target's control file.
• B.A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• C.Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• D.Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISOR package.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATS package.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

• A.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• B.The REVENUE table must be a composite-partitioned table.
• C.The REVENUE table partitions are not pruned across the PDBs automatically.
• D.The REVENUE table must be a list-partitioned table.
• E.The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.

Comment: *

Name: *

Email: *

Verification: *