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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

• A.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
• B.SQL statements doing only logical reads never require tuning because they do no physical I/O.
• C.The solution that best optimizes one SQL statement can degrade the performance of others.
• D.SQL statements doing joins always do more physical I/O than single table queries.
• E.Poorly performing SQL statements can be tuned automatically by the Oracle server.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Database Point-in-Time Recovery? (Choose three.)

• A.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• B.The database must be open RESETLOGS after Database Point-in-Time Recovery.
• C.The database must be in MOUNT state when performing Database Point-in-Time Recovery.
• D.The target point for the recovery must be specified as a stime or System Change Number (SCN).
• E.The Database must be in ARCHIVELOG mode.
• F.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

Comment: *

Name: *

Email: *

Verification: *

RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog? (Choose two.)

• A.when a new tablespace is added to a registered target database
• B.when a backup of the current control file is created
• C.when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
• D.when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
• E.when the target is first registered

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN backups when using a media manager? (Choose two.)

• A.A media manager is required to create RMAN image copies.
• B.The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
• C.A media manager is required to create RMAN proxy copies.
• D.By default, a request for a proxy copy may result in a backup set being created.
• E.A media manager always writes RMAN requested backups to tape.

Comment: *

Name: *

Email: *

Verification: *