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 backup of the current control file is created
• B.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
• 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 the target is first registered
• E.when a new tablespace is added to a registered target database

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

• A.A PDB snapshot can be a sparse copy of a source PDB.
• B.A PDB snapshot can be a full copy of a source PDB.
• C.A snapshot copy PDB can be a full copy of a source PDB.
• D.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• E.A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• F.A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• G.A PDB snapshot depends on an existing storage snapshot of the source PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A.the physical data model
• B.defining primary keys for all tables to speed up all queries
• C.the configuration of storage arrays
• D.using check constraints to speed up updates
• E.defining foreign keys for all tables to speed up joins

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

Choose three. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?

• A.If an RMAN command fails, the output will identify the channel ID where the failure occurred. D)Media Management errors appear as a line with "Additional information" and a number.
• B.Some messages in the error stack are not errors.
• C.If an RMAN command fails, the output will only identify the command that failed.
• D.Media Management errors appear as a line with "sbtio" and a number.
• E.Media Management errors appear as a line with "sbtio".

Comment: *

Name: *

Email: *

Verification: *