Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

• A.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• B.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• C.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.
• D.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• E.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• F.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• H.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

Comment: *

Name: *

Email: *

Verification: *

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:

Which two are true? (Choose two.)

• A.The CONTAINERS clause cannot be used in queries on the REVENUE table.
• B.A container map exists for the REVENUE table, but is not enabled.
• C.The REVENUE table partitions are not pruned across the PDBs automatically.
• D.The MAPTABLE table is a metadata-linked table.
• E.The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
• F.The REVENUE table must be a list-partitioned table.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about instance recovery? (Choose two.)

• A.It is performed by the Recovery Writer (RVWR) background process.
• B.Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
• C.It is performed automatically while the database remains in MOUNT state. Then the database is opened.
• D.Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
• E.It is not possible if an archived log is missing.
• F.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

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: *

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.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• C.backing up the cloned PDB
• D.opening the cloned PDB
• 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: *