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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

• A.It can be used to provision applications.
• B.It cannot be used to upgrade Oracle Database homes.
• C.It can be used to provision middleware.
• D.It is an Oracle Database service
• E.It can be used to patch Grid Infrastructure homes containing Oracle Restart.

Comment: *

Name: *

Email: *

Verification: *

Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?

• A.after losing an UNDO tablespace that is in use
• B.after losing all members of the CURRENT online redo log group
• C.after losing a SYSAUX tablespace data file
• D.after losing all copies of the control file
• E.after losing all members of an INACTIVE online redo log group

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

• A.to switch an existing Oracle Database home to a newer release of Oracle software on the same server
• B.to switch to a read-only Oracle home
• C.to switch back to the previous Oracle home as part of a rollback operation
• D.to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
• E.to switch to a patched Oracle Database home

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *