Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

• A.cloning a remote pluggable database in silent mode
• B.cloning a remote container database in silent mode
• C.relocating a remote container database in interactive mode
• D.relocating a remote container database in silent mode
• E.relocating a remote pluggable database in interactive mode
• F.cloning a remote container database in interactive mode
• G.relocating a remote pluggable database in silent mode

Comment: *

Name: *

Email: *

Verification: *

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

• A.You can
• B.You can
• C.You can
• D.You can
• E.You can

Comment: *

Name: *

Email: *

Verification: *

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

• A.Poorly performing SQL statements can be tuned automatically by the Oracle server.
• 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 performing many physical I/Os can always have their performance improved by creating indexes.
• E.SQL statements doing joins always do more physical I/O than single table queries.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.Only the grid user can perform the upgrade.
• B.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• C.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• D.An existing Oracle base can be used.
• E.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• F.Existing Oracle Database instances must be shut down before starting the upgrade.

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be recovered while connected to CDB$ROOT.
• B.Data file 24 can be restored only while connected toCDB$ROOT.
• C.Data file 24 can be recovered while connected to PDB2.
• D.Data file 24 can be restored only while connected to PDB2.
• E.Data file 24 can be recovered only while connected to PDB2.
• F.Data file 24 can be restored and recovered while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *