Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?

• A.Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.
• B.An Oracle database can be restored from backup files copied using O/S utilities.
• C.Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be shut down.
• D.Backing up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in open state.
• E.Backing up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.
• F.Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as image copies.
• G.Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics? (Choose two.)

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
• E.System statistics can be gathered only while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

• A.Create the PDB1 application PDB and synchronize it with PDB$SEED.
• B.Create the PDB1 application PDB and install HR_APP in it.
• C.Create the PDB1 application PDB and synchronize it with HR_ROOT.
• D.Create an application seed, and install HR_APP in it.
• E.Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

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 restored and recovered while connected to CDB$ROOT.
• B.Data file 24 can be restored only while connected to CDB$ROOT.
• C.Data file 24 can be recovered while connected to CDB$ROOT.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be restored only while connected to PDB2.
• F.Data file 24 can be recovered only while connected to PDB2.

Comment: *

Name: *

Email: *

Verification: *