Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A.A PDB snapshot is always a full copy of the source PDB.
• B.A PDB snapshot is always a sparse copy of the source PDB.
• C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G.A snapshot copy PDB can be created from a stand-alone clone PDB.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

• A.ADDM can run in a nonroot container.
• B.AWR reports can be generated while connected to any container.
• C.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• D.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• E.AWR snapshots can be created in a PDB.
• F.AWR snapshots can be created in CDB$ROOT.

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A.RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• B.The RMAN LOG command line clause causes output issued during RMAN commandcompilation to be written to a log file and to standard output.
• C.RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• D.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• E.Media Management messages for SBT devices are written to an Oracletrace file.
• F.Media Management messages for SBT devices are always written to sbtio.log.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

• A.A subset of the target database can be duplicated.
• B.A backup of the target database is always required.
• C.A connection to the recovery catalog instance is always required.
• D.Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• E.A new DBID is always created for the duplicated database.
• F.A connection to an auxiliary instance is always required.
• G.A connection to the target database instance is always required.
• H.Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

Comment: *

Name: *

Email: *

Verification: *