Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A.A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• B.The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.
• C.A target database's persistent RMAN configuration settings are always stored in the target's control file
• D.Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• E.The RMAN SHOW ALL command displays only settings with nondefault values.
• F.Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

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

• A.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.
• B.Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
• C.An Oracle database can be restored from backup files copied using O/S utilities.
• D.Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• E.Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• F.Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
• G.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.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about recovering tables using RMAN?

• A.RMAN can recover tables in the SYSTEM tablespace.
• B.RMAN can recover tables owned by the SYS user.
• C.RMAN can recover tables in a standby database.
• D.RMAN can recover tables owned by the SYSTEM user.
• E.RMAN always uses an auxiliary instance.
• F.RMAN can recover a table after a DDL operation has altered the table structure.
• G.RMAN can recover tables in the SYSAUX tablespace.

Comment: *

Name: *

Email: *

Verification: *

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true?

• A.All archive logs created after this backup are kept for two years.
• B.The control file is included in the self-contained archival backup.
• C.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• D.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
• E.The spfile is included in the self-contained archival backup.
• F.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

Comment: *

Name: *

Email: *

Verification: *