CCNA Backup And Recovery Questions

Multi-Selectmedium

Which TWO actions are required to enable Flashback Database on a production environment?

Select 2 answers

A.Restart the database in UPGRADE mode.

B.Ensure the database is in ARCHIVELOG mode.

C.Set DB_RECOVERY_FILE_DEST_SIZE to zero.

D.Set the DB_FLASHBACK_RETENTION_TARGET parameter.

E.Drop all existing restore points.

AnswersB, D

This is a mandatory prerequisite for Flashback Database.

Why this answer

Flashback Database requires the database to be in ARCHIVELOG mode and the recovery area to be configured.

Practice this question →

Multi-Selectmedium

Which TWO statements are true regarding the use of a Recovery Catalog?

Select 2 answers

A.It can be used to store backup scripts.

B.It is required to perform RMAN backups.

C.It is physically located inside the target database.

D.It stores metadata about backups for multiple databases.

E.It eliminates the need for control file autobackups.

AnswersA, D

Persistent scripts are a key feature of the catalog.

Why this answer

A recovery catalog provides history beyond the control file limit and centralizes metadata for multiple databases.

Practice this question →

MCQmedium

What is the primary function of the RMAN 'SWITCH' command?

A.To move the database to a new server.

B.To update the control file to point to a new datafile copy.

C.To switch between primary and standby.

D.To switch the log file.

AnswerB

This is the primary function of SWITCH.

Why this answer

The SWITCH command updates the control file to point to a new location for datafiles, typically after a copy has been restored.

Practice this question →

MCQhard

You are performing a cross-platform transportable tablespace migration from Linux to Windows. Which RMAN command is required to convert the datafiles for the destination platform?

A.ALTER TABLESPACE ... CONVERT;

B.RMAN TRANSPORT ...

C.CONVERT TABLESPACE ... TO PLATFORM 'Microsoft Windows x86 64-bit';

D.RMAN COPY ...

AnswerC

This correctly identifies the destination platform endian format.

Why this answer

The CONVERT TABLESPACE command is used to change the endian format for cross-platform migrations.

Practice this question →

MCQeasy

You need to perform a table-level point-in-time recovery. Which RMAN command syntax is correct?

A.RESTORE TABLE ...

B.RECOVER TABLE HR.EMPLOYEES UNTIL SCN 12345;

C.FLASHBACK TABLE ...

D.IMPORT TABLE ...

AnswerB

Correct syntax for table PITR.

Why this answer

RECOVER TABLE ... UNTIL SCN is the syntax for table-level recovery.

Practice this question →

MCQeasy

Which RMAN command displays the database structure and associated datafiles?

A.DESCRIBE DATABASE

B.LIST SCHEMA

C.SHOW SCHEMA

D.REPORT SCHEMA

AnswerD

This command displays the current database architecture.

Why this answer

REPORT SCHEMA shows the layout of the database and its datafiles.

Practice this question →

MCQhard

You are migrating an Oracle 23ai database to a different platform with different endianness. Which RMAN command is used to convert the datafiles to the target platform format?

A.RMAN> CONVERT DATABASE ON TARGET PLATFORM;

B.RMAN> CONVERT DATAFILE '...' TO PLATFORM '...' FROM PLATFORM '...';

C.RMAN> RESTORE DATAFILE FROM PLATFORM;

D.ALTER DATABASE CONVERT TO PLATFORM;

AnswerB

This correctly identifies the source and destination endian formats for conversion.

Why this answer

The CONVERT DATAFILE command is required when the source and destination platforms have different endian formats.

Practice this question →

MCQmedium

You are configuring a recovery catalog in Oracle 23ai. Which command must you execute first to ensure the catalog is ready to register the target database?

A.CREATE CATALOG;

B.REGISTER DATABASE;

C.CONNECT CATALOG;

D.UPGRADE CATALOG;

AnswerA

This command creates the necessary tables in the RMAN schema.

Why this answer

The CREATE CATALOG command must be executed to initialize the schema before registration.

Practice this question →

Multi-Selectmedium

Which TWO of the following are valid methods to move a database across platforms using RMAN?

Select 2 answers

A.Transportable Tablespaces

B.RMAN DUPLICATE DATABASE FROM ACTIVE DATABASE

C.Data Pump Export/Import with Full Database mode

D.RMAN BACKUP AS COPY

E.RMAN CONVERT DATABASE

AnswersA, E

A standard method for moving data across platforms using RMAN/Data Pump.

Why this answer

Transportable Tablespaces and RMAN CONVERT DATABASE are the two primary supported methods for moving data across platforms.

Practice this question →

Multi-Selecthard

Which THREE tasks are performed by the 'RECOVER' command during a data file restore?

Select 3 answers

A.Restoring the datafiles from backup.

B.Applying archived redo logs.

C.Applying the online redo logs.

D.Creating new control files.

E.Verifying the headers of the datafiles.

AnswersB, C, E

Recovery involves applying logs to reach the desired point.

Why this answer

It applies logs, verifies file status, and marks files as online.

Practice this question →

Multi-Selecthard

Which THREE are characteristics of Flashback Logs?

Select 3 answers

A.They are stored in the Fast Recovery Area (FRA).

B.They are backed up using RMAN.

C.They are circular in nature.

D.They contain redo information.

E.They are used to revert the database state.

AnswersA, C, E

FRA is the dedicated location for flashback logs.

Why this answer

They are stored in the FRA, they are circular, and they are not backups.

Practice this question →

Multi-Selectmedium

Which TWO of the following are valid RMAN retention policies?

Select 2 answers

A.CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

B.CONFIGURE RETENTION POLICY TO 100GB;

C.CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

D.CONFIGURE RETENTION POLICY TO NONE;

E.CONFIGURE RETENTION POLICY TO INFINITE;

AnswersA, C

This is a valid redundancy-based policy.

Why this answer

Redundancy and Recovery Window are the two primary retention policies.

Practice this question →

MCQeasy

Which RMAN command should you use to verify that your backup pieces are not corrupted?

A.VALIDATE BACKUPSET

B.LIST BACKUP

C.CROSSCHECK BACKUP

D.RESTORE DATABASE VALIDATE

AnswerA

This is the specific command to check backup piece integrity.

Why this answer

VALIDATE BACKUPSET checks the integrity of the backup pieces.

Practice this question →

MCQmedium

You are using RMAN to backup a database. What does the 'COMPRESS' clause in the backup command do?

A.It validates the backup.

B.It encrypts the backup.

C.It reduces the backup size.

D.It speeds up the backup.

AnswerC

Compression reduces the stored file size.

Why this answer

The 'COMPRESS' clause reduces the size of the backup pieces by applying compression, saving storage space.

Practice this question →

MCQeasy

You need to ensure that RMAN automatically deletes archived redo logs after they have been backed up twice to tape. Which configuration command should you use?

A.CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE SBT;

B.CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

C.SET ARCHIVELOG DELETION POLICY TO 2 COPIES;

D.CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

AnswerA

This is the correct syntax for setting the deletion policy based on backup redundancy.

Why this answer

The CONFIGURE ARCHIVELOG BACKUP COPIED command with the TO DEVICE TYPE and num_copies parameters defines the retention policy for archived logs.

Practice this question →

Multi-Selecthard

Which THREE pieces of information are needed to restore a database to a specific point-in-time using RMAN?

Select 3 answers

A.The operating system password.

B.The current SPFILE.

C.The DBID of the database.

D.A valid control file backup.

E.The target timestamp or SCN.

AnswersC, D, E

Required if the control file is lost.

Why this answer

You need the DBID, the control file, and the point-in-time target.

Practice this question →

Multi-Selectmedium

Which TWO RMAN configurations are recommended to optimize backup performance in a high-transaction environment?

Select 2 answers

A.CONFIGURE DEVICE TYPE DISK PARALLELISM 4;

B.CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';

C.ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

D.CONFIGURE MAXSETSIZE TO 10G;

E.CONFIGURE CONTROLFILE AUTOBACKUP OFF;

AnswersA, C

Increasing parallelism allows RMAN to read multiple datafiles simultaneously.

Why this answer

Parallelism and block change tracking are primary performance tuners.

Practice this question →

Multi-Selecthard

Which THREE are true regarding the use of 'FLASHBACK DATABASE'?

Select 3 answers

A.It deletes all archivelogs.

B.It requires the database to be in open state.

C.It can be performed on a closed database.

D.A Fast Recovery Area must be configured.

E.The database must be in ARCHIVELOG mode.

AnswersC, D, E

Flashback database is performed while the database is mounted.

Why this answer

It requires FRA, archivelog mode, and flashback logs.

Practice this question →

MCQeasy

Which RMAN command is used to start an RMAN session?

A.run rman

B.rman target /

C.start rman

D.sqlplus rman

AnswerB

This connects RMAN to the local database.

Why this answer

The 'rman' command is invoked from the operating system prompt to start the tool.

Practice this question →

Multi-Selecthard

Which THREE tasks are required when preparing for a database recovery using a new control file?

Select 3 answers

A.Perform RECOVER DATABASE USING BACKUP CONTROLFILE.

B.Mount the database.

C.Restore the control file from a backup.

D.Delete all existing archivelogs.

E.Open the database resetlogs.

AnswersA, B, C

This is necessary when the control file is replaced.

Why this answer

You need to restore, mount, and recover.

Practice this question →

Multi-Selecteasy

Which THREE components are included in an RMAN 'BACKUP DATABASE' command if not explicitly excluded?

Select 3 answers

A.Control File

B.Temporary Tablespace

C.SPFILE

D.Redo Logs

E.Datafiles

AnswersA, C, E

The control file is included when autobackup is enabled.

Why this answer

By default, RMAN backs up datafiles, the current control file, and spfile (if autobackup is enabled).

Practice this question →

MCQmedium

You are configuring a RMAN backup strategy for a multitenant container database (CDB) and want to ensure that a backup of the root container also includes all PDBs. Which configuration command achieves this automatically?

A.BACKUP DATABASE

B.CONFIGURE INCLUDE PDB BACKUP ON

C.CONFIGURE CDB BACKUP ALL ON

D.BACKUP CONTAINER ALL

AnswerA

In a CDB, issuing BACKUP DATABASE covers the root and all pluggable databases by default.

Why this answer

The 'CONFIGURE PDB BACKUP OPTIMIZATION ON' command is not for this, but 'CONFIGURE BACKUP OPTIMIZATION ON' is standard. Specifically, 'BACKUP DATABASE' in a CDB context handles all PDBs unless excluded.

Practice this question →

MCQhard

You are performing a cross-platform data migration using RMAN CONVERT. The destination platform has different endianness. Which file type must be converted before it can be transported?

A.Redo log files

B.Parameter files

C.Datafiles

D.Control files

AnswerC

Datafiles require endianness conversion when moving between platforms with different endian formats.

Why this answer

Datafiles in a platform with different endianness must be converted using the CONVERT command to be readable by the target instance.

Practice this question →

MCQhard

You are restoring a database and need to use a backup control file. Which clause is mandatory in the recover command?

A.WITH EXTERNAL CONTROLFILE

B.USING BACKUP CONTROLFILE

C.RECOVER CONTROLFILE

D.USING OLD CONTROLFILE

AnswerB

This is the required clause.

Why this answer

The 'USING BACKUP CONTROLFILE' clause is required when you are not using the current control file.

Practice this question →

MCQmedium

You are configuring RMAN to store backup metadata in a Recovery Catalog. What is the benefit of using a catalog over the target database control file for long-term backup retention?

A.It supports storing backup metadata for longer than the control_file_record_keep_time initialization parameter.

B.It allows RMAN to perform backups while the database is in NOARCHIVELOG mode.

C.It automatically encrypts all RMAN backup sets.

D.It is required for using the RECOVERY WINDOW retention policy.

AnswerA

The catalog is not subject to the circular reuse constraints of the control file.

Why this answer

A recovery catalog provides a persistent repository that is independent of the target database control file, allowing for retention periods longer than the control_file_record_keep_time.

Practice this question →

MCQmedium

In a multitenant environment, what is the best approach to backup only a specific PDB?

A.BACKUP CDB PDB pdb_name

B.BACKUP DATABASE PDBNAME

C.BACKUP PLUGGABLE DATABASE pdb_name

D.BACKUP PDB ALL

AnswerC

This is the correct command for PDB-level backups.

Why this answer

You can use the 'BACKUP PLUGGABLE DATABASE' command to target a specific PDB.

Practice this question →

MCQmedium

You are investigating an RMAN backup failure. The log indicates that RMAN is unable to access the recovery area. Which view should you query to check the current space usage of the Fast Recovery Area?

A.V$FLASHBACK_DATABASE_LOG

B.V$DATABASE_BLOCK_CORRUPTION

C.V$RMAN_STATUS

D.V$RECOVERY_FILE_DEST

AnswerD

This view is the standard for checking FRA utilization.

Why this answer

V$RECOVERY_FILE_DEST provides the directory, space limit, and space used for the FRA.

Practice this question →

MCQmedium

Your database is in ARCHIVELOG mode. You accidentally dropped a critical tablespace and need to perform a Tablespace Point-in-Time Recovery (TSPITR). What is the primary requirement for the auxiliary instance during this process?

A.The auxiliary instance must have enough disk space to hold the tablespace being recovered.

B.The auxiliary instance must have the same DBID as the target database.

C.The auxiliary instance must be configured with a separate ORACLE_HOME.

D.The auxiliary instance must be started in NOMOUNT mode manually by the DBA.

AnswerA

The auxiliary instance is used to restore and recover the datafiles to the point in time.

Why this answer

TSPITR requires an auxiliary instance to recover the tablespace to the desired point in time before importing it back to the target database.

Practice this question →

MCQhard

You have a standby database and want to use RMAN to offload backups to the standby. Which configuration is required to ensure the primary database recognizes the backups performed on the standby?

A.CONFIGURE CONNECT IDENTIFIER FOR DEFAULT SERVICE TO 'standby_service';

B.CONFIGURE BACKUP OPTIMIZATION ON;

C.Enable Flashback Database on the primary only.

D.CONFIGURE CONTROLFILE AUTOBACKUP FOR BACKUP ON STANDBY ON;

AnswerD

This setting allows RMAN to perform autobackups of the control file from the standby site.

Why this answer

To use a standby for backups, you must connect RMAN to the recovery catalog and the standby database, and ensure the configuration includes 'CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY'.

Practice this question →

MCQeasy

What happens if a block is marked as corrupt during an RMAN backup?

A.The backup terminates immediately.

B.The backup is marked as 'failed' in the recovery catalog.

C.The information is recorded in the V$DATABASE_BLOCK_CORRUPTION view.

D.The corrupt blocks are repaired automatically.

AnswerC

This is the standard behavior to track corruption.

Why this answer

RMAN writes the corruption information to V$DATABASE_BLOCK_CORRUPTION but continues the backup unless the number of errors exceeds MAXCORRUPT.

Practice this question →

MCQhard

You are performing an RMAN duplicate database operation. What is the benefit of using the 'FROM ACTIVE DATABASE' clause?

A.It requires less network bandwidth.

B.It is faster than restoring from backup.

C.It does not require a connection to the target.

D.It creates a backup of the source during duplication.

AnswerB

It avoids the backup-restore cycle by copying live data.

Why this answer

It duplicates the database directly from the source without requiring a backup set to be restored first.

Practice this question →

MCQhard

You have a standby database and want to offload backups to it. What is the recommended way to register the standby's backups in the recovery catalog?

A.Run the register command on the primary.

B.Connect RMAN to the standby and the catalog.

C.Export the primary catalog metadata to the standby.

D.Use the import command in RMAN.

AnswerB

Backups performed on the standby are registered by connecting the standby instance to the catalog.

Why this answer

The standby database should be connected to the recovery catalog to register its own backups.

Practice this question →

MCQmedium

You want to perform a backup that excludes tablespaces that are read-only. Which command should you use?

A.BACKUP DATABASE IGNORE READONLY

B.BACKUP DATABASE EXCEPT READONLY

C.CONFIGURE EXCLUDE READONLY ON

D.BACKUP DATABASE SKIP READONLY

AnswerD

This clause specifically ignores read-only tablespaces.

Why this answer

RMAN automatically skips read-only tablespaces in incremental backups, or you can use the 'SKIP READONLY' clause.

Practice this question →

MCQmedium

You want to backup the control file automatically whenever a change is made to the database structure. Which command do you use?

A.CONFIGURE CONTROLFILE AUTOBACKUP ON

B.BACKUP CONTROLFILE ON

C.ALTER SYSTEM SET CONTROLFILE_AUTOBACKUP=TRUE

D.SET CONTROLFILE AUTOBACKUP ON

AnswerA

This is the correct command.

Why this answer

CONFIGURE CONTROLFILE AUTOBACKUP ON enables automatic control file backups.

Practice this question →

Multi-Selecthard

Which THREE steps are involved in an RMAN-based cross-platform migration of a data file using CONVERT?

Select 3 answers

A.Run the RECOVER DATABASE command on the source.

B.Transport the converted file to the target.

C.Perform a BACKUP AS COPY of the datafile.

D.Run the CONVERT command on the source.

E.Disable Archivelog mode on the target.

AnswersB, C, D

The file must be moved to the target server.

Why this answer

The process requires the file to be backed up, converted, and moved to the destination.

Practice this question →

Multi-Selecthard

Which THREE conditions must be met to perform a successful RMAN cross-platform transportable tablespace migration?

Select 3 answers

A.The source platform must be the same endian as the target.

B.The RMAN CONVERT command must be used if endianness differs.

C.The source and destination databases must have the same DBID.

D.The source tablespace must be set to READ ONLY.

E.The compatibility level must be at least 11.0.0.

AnswersB, D, E

Conversion is required if moving between platforms with different endianness.

Why this answer

The databases must be at compatible levels, endian formats must be checked, and the tablespace must be read-only.

Practice this question →

MCQhard

You are performing a TSPITR (Tablespace Point-in-Time Recovery). What is the purpose of the auxiliary instance?

A.To act as a standby database.

B.To host the recovery catalog.

C.To manage the control file backups.

D.To perform the recovery of the target tablespaces.

AnswerD

The auxiliary instance hosts the recovered tablespaces temporarily.

Why this answer

The auxiliary instance is used to restore and recover the target tablespaces to the desired point in time before exporting the data back to the primary database.

Practice this question →

Multi-Selecthard

Which THREE actions are performed during the 'RESTORE DATABASE' command?

Select 3 answers

A.Restoring datafiles to the disk.

B.Updating the control file with file locations.

C.Opening the database with RESETLOGS.

D.Verifying the integrity of the backup pieces.

E.Performing media recovery.

AnswersA, B, D

This is the primary restore action.

Why this answer

Restoring files, updating the control file, and verifying existence are key.

Practice this question →

MCQhard

A user accidentally dropped a critical table. You decide to use Flashback Table. What is the mandatory prerequisite before this command can execute?

A.The table must have a Primary Key.

B.The database must be in ARCHIVELOG mode.

C.The Recycle Bin must be disabled.

D.Row movement must be enabled on the table.

AnswerD

Flashback Table requires 'ENABLE ROW MOVEMENT' to reconstruct the row IDs.

Why this answer

Row movement must be enabled for the table to move rows back to their original IDs, and flashback must be enabled.

Practice this question →

MCQeasy

If you are in ARCHIVELOG mode, what is the primary benefit of having a multiplexed control file?

A.Faster backup performance.

B.Redundancy against disk failure.

C.Ability to perform point-in-time recovery.

D.Automatic database tuning.

AnswerB

Having multiple copies protects against single-device failure.

Why this answer

Multiplexing control files provides fault tolerance against disk failure of the control file location.

Practice this question →

MCQeasy

Which command is used to delete backups that are no longer needed based on the current retention policy?

A.DROP BACKUP

B.DELETE OBSOLETE

C.PURGE BACKUPS

D.DELETE BACKUP

AnswerB

This respects the CONFIGURE RETENTION POLICY setting.

Why this answer

DELETE OBSOLETE is the command to purge backups exceeding the retention policy.

Practice this question →

MCQhard

You are performing a cross-platform data migration. The source is Linux and the destination is Windows. Which RMAN tool do you use to convert the datafiles?

A.RMAN IMPORT

B.RMAN TRANSPORT

C.RMAN CONVERT

D.RMAN MIGRATION

AnswerC

The CONVERT command handles cross-endian migration.

Why this answer

The CONVERT command is used for cross-platform endianness issues.

Practice this question →

Multi-Selectmedium

Which TWO RMAN settings significantly improve performance during backup operations on an Exadata system?

Select 2 answers

A.CONFIGURE CHANNEL ... RATE 10M;

B.CONFIGURE MAXSETSIZE UNLIMITED;

C.CONFIGURE BACKUP OPTIMIZATION ON;

D.CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;

E.CONFIGURE CONTROLFILE AUTOBACKUP OFF;

AnswersC, D

Skips files that haven't changed.

Why this answer

Backup optimization and parallelism settings directly impact throughput on high-performance storage.

Practice this question →

MCQmedium

You need to perform a full database restore and recovery. The control file is lost. What is the correct sequence of operations?

A.RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;

B.RESTORE SPFILE; STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN;

C.FLASHBACK DATABASE TO RESTORE POINT; ALTER DATABASE OPEN;

D.STARTUP NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;

AnswerD

This is the standard procedure for restoring a database when the control file is lost.

Why this answer

After losing the control file, you must restore it from an autobackup before you can restore the datafiles and perform recovery.

Practice this question →

MCQeasy

What command would you use to list all backups associated with a particular database in the recovery catalog?

A.REPORT BACKUP

B.LIST BACKUP

C.SHOW BACKUP

D.DISPLAY BACKUP

AnswerB

This lists all known backups.

Why this answer

LIST BACKUP is the standard command for this.

Practice this question →

Multi-Selecthard

Which THREE operations are automatically performed by RMAN when executing the 'RECOVER TABLE' command?

Select 3 answers

A.Exporting the recovered table to the target database using Data Pump

B.Restoration of the tablespace containing the table to an auxiliary location

C.Automatic deletion of all backups older than the restore point

D.Creation of an auxiliary instance

E.Automatic conversion of the database to NOARCHIVELOG mode

AnswersA, B, D

Data Pump is used to import the table back into the target database.

Why this answer

The RECOVER TABLE command creates an auxiliary instance, performs a partial restore and recovery of the tablespace containing the table, and then exports the table metadata to the target database.

Practice this question →

MCQmedium

You are performing a cross-platform data migration from a Linux-based Oracle 23ai source database to a Solaris target. You intend to use RMAN CONVERT DATABASE. Which prerequisite must be met to ensure the migration succeeds?

A.The source database must use Automatic Storage Management (ASM).

B.The target database must be in ARCHIVELOG mode before starting the conversion.

C.The source and target platforms must have the same endian format.

D.The source database must be in restricted mode.

AnswerC

RMAN CONVERT DATABASE is only supported when the source and target platforms have identical endianness.

Why this answer

When converting a database using RMAN, the source and target platforms must have the same endian format, or the conversion must be done via transportable tablespaces if the endianness differs. RMAN CONVERT DATABASE requires the platforms to share endianness.

Practice this question →

MCQhard

You need to perform a Table Point-in-Time Recovery (TPITR) to restore a table to a state before a mistaken DROP TABLE operation. Which RMAN command performs this operation while minimizing impact to other tablespaces?

A.RECOVER TABLE ... UNTIL SCN ...;

B.FLASHBACK TABLE ... TO SCN ...;

C.IMPORT FROM BACKUPSET ...;

D.RESTORE TABLE ... UNTIL SCN ...;

E.null

AnswerA

RECOVER TABLE is the correct RMAN command for performing TPITR on a single table.

Why this answer

The RECOVER TABLE command is specifically designed for table-level recovery, which creates an auxiliary instance automatically to extract the table data.

Practice this question →

MCQeasy

A database is configured with a Flash Recovery Area (FRA). You want to ensure that RMAN automatically deletes obsolete backups to reclaim space in the FRA. Which command should you configure?

A.CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

B.CONFIGURE SNAPSHOT CONTROLFILE NAME TO '...';

C.CONFIGURE CONTROLFILE AUTOBACKUP ON;

D.CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

AnswerA

Setting a retention policy allows RMAN to identify files as obsolete when they fall outside the policy, enabling the FRA to reclaim that space.

Why this answer

The CONFIGURE RETENTION POLICY TO RECOVERY WINDOW or REDUNDANCY command, combined with the automatic management of the FRA, allows RMAN to delete obsolete backups when space is required.

Practice this question →

MCQeasy

What is the default location for RMAN backups if no FRA is configured?

A.The system tablespace.

B.The database home directory.

C.The redo log path.

D.The current working directory of the RMAN session.

AnswerD

Without FRA, it defaults to the current directory.

Why this answer

If no FRA is configured, RMAN defaults to the location defined by the OS or the current directory, but it is best practice to configure the FRA.

Practice this question →

Multi-Selecthard

Which THREE of the following are prerequisites for performing an RMAN backup to an Oracle Cloud Infrastructure (OCI) Object Storage bucket?

Select 3 answers

A.A backup configuration file defining the bucket and compartment.

B.The database must be migrated to 23ai.

C.A wallet containing the OCI credentials must be created.

D.The database must be in NOARCHIVELOG mode.

E.The SBT_LIBRARY must be configured to point to the OCI library.

AnswersA, C, E

The config file provides the necessary path information for OCI storage.

Why this answer

You need the OCI SDK, a configuration file, and the correct library.

Practice this question →

MCQeasy

What is the primary purpose of the Flashback Database feature?

A.To restore individual corrupted datafiles

B.To recover dropped tables

C.To revert the entire database to a point in time

D.To undo a specific transaction

AnswerC

Flashback Database provides a fast way to revert the database state.

Why this answer

Flashback Database allows you to return the entire database to a previous point in time without restoring from a backup.

Practice this question →

MCQmedium

Which RMAN command allows you to verify that all database files are present and accessible without performing a full backup?

A.REPORT NEED BACKUP

B.CROSSCHECK

C.LIST FILE

D.VALIDATE DATABASE

AnswerB

CROSSCHECK checks the physical existence of backups.

Why this answer

CROSSCHECK verifies the status of files in the catalog against the physical files on disk.

Practice this question →

MCQmedium

You are using Block Change Tracking (BCT). Where is the BCT file stored?

A.In the Fast Recovery Area (FRA).

B.In the SYSTEM tablespace.

C.In the control file.

D.In the redo log files.

AnswerA

By default, it is stored in the FRA.

Why this answer

The BCT file is managed by the database and typically stored in the FRA or as defined by the DB_BLOCK_CHANGETRACKING_FILE parameter.

Practice this question →

Multi-Selectmedium

Which TWO actions occur during a RMAN 'BACKUP AS COPY' operation?

Select 2 answers

A.Datafiles are compressed into a single backup piece.

B.The output file is an exact image copy of the datafile.

C.The file can be used immediately without RMAN restore.

D.The backup is stored in the RMAN proprietary backup format.

E.The backup is automatically encrypted.

AnswersB, C

An image copy is a direct, uncompressed copy of the file.

Why this answer

A backup copy is a direct image copy, not an RMAN backup set, and is stored as an exact bit-for-bit file.

Practice this question →

Multi-Selectmedium

Which TWO conditions are required for Block Change Tracking (BCT) to be effective?

Select 2 answers

A.Block Change Tracking must be enabled.

B.Incremental backups must be performed.

C.The database must be in restricted mode.

D.The database must be in ARCHIVELOG mode.

E.Flashback Database must be enabled.

AnswersA, B

It is not enabled by default.

Why this answer

BCT must be enabled and an incremental backup must be performed.

Practice this question →

MCQmedium

You are performing a tablespace recovery. What is the first thing that must happen to the tablespace before recovery can start?

A.The tablespace must be set to read-only.

B.The database must be shut down.

C.The database must be in restricted mode.

D.The tablespace must be taken offline.

AnswerD

Tablespace recovery requires the tablespace to be offline.

Why this answer

The tablespace must be taken offline to perform recovery on its constituent datafiles.

Practice this question →

MCQhard

Which RMAN configuration must be set to ensure that backups are automatically deleted when they are no longer needed?

A.CONFIGURE AUTO DELETE ON

B.SET RETENTION POLICY

C.CONFIGURE RETENTION POLICY

D.CONFIGURE OBSOLETE ON

AnswerC

This sets the policy for retention.

Why this answer

CONFIGURE RETENTION POLICY defines the criteria for what is obsolete.

Practice this question →

MCQmedium

Which configuration parameter determines the maximum size of a backup piece?

A.CONFIGURE MAXPIECESIZE

B.SET BACKUPPIECE SIZE

C.CONFIGURE CHANNEL MAXSIZE

D.CONFIGURE MAXSETSIZE

AnswerD

This is the correct RMAN command.

Why this answer

CONFIGURE MAXSETSIZE is the parameter used to cap the size of a backup set.

Practice this question →

MCQeasy

Which RMAN command should you use to verify that all blocks in your database datafiles are free from physical corruption without actually performing a restore?

A.RECOVER DATABASE TEST;

B.CHECK DATAFILES;

C.BACKUP VALIDATE DATABASE;

D.RESTORE DATABASE VALIDATE;

AnswerC

The BACKUP VALIDATE command checks the datafiles for physical and logical corruption.

Why this answer

The VALIDATE command checks for physical and logical block corruption in datafiles, control files, and backup sets.

Practice this question →

Multi-Selectmedium

Which TWO commands allow you to check for block corruption in a database?

Select 2 answers

A.SELECT * FROM V$LOG

B.BACKUP VALIDATE DATABASE

C.ALTER SYSTEM CHECK

D.RECOVER DATABASE

E.ANALYZE TABLE ... VALIDATE STRUCTURE

AnswersB, E

This is the standard RMAN way to check for physical corruption.

Why this answer

ANALYZE TABLE and RMAN validate are the primary methods.

Practice this question →

Multi-Selectmedium

Which TWO of the following are benefits of using an RMAN recovery catalog?

Select 2 answers

A.Stores backup metadata for multiple databases.

B.Automatically encrypts all backups.

C.Eliminates the need for archivelogs.

D.Provides faster database performance.

E.Allows keeping backup history longer than the control file.

AnswersA, E

This is a primary benefit.

Why this answer

Centralization and extended retention are key benefits.

Practice this question →

Multi-Selecthard

Which THREE features are required for using Flashback Database?

Select 3 answers

A.A Fast Recovery Area (FRA) must be configured.

B.The database must be in NOARCHIVELOG mode.

C.Database must be in ARCHIVELOG mode.

D.The database must be a standby.

E.Flashback logs must be enabled.

AnswersA, C, E

FRA stores the flashback logs.

Why this answer

Flashback Database requires the recovery area, flashback logs, and the database to be in ARCHIVELOG mode.

Practice this question →

MCQeasy

How do you check the status of all current RMAN backup jobs?

A.SHOW ALL

B.LIST JOB SUMMARY

C.SELECT * FROM V$RMAN_STATUS

D.REPORT SCHEMA

AnswerC

This view is the standard for monitoring job progress.

Why this answer

V$RMAN_STATUS provides the most comprehensive view of backup job history and status.

Practice this question →

MCQmedium

You want to perform a point-in-time recovery to a specific timestamp. Which RMAN command is used to set the target time?

A.FLASHBACK DATABASE TO TIME '2023-10-10:10:00:00'

B.SET TIME '2023-10-10 10:00:00'

C.RECOVER DATABASE TO '2023-10-10:10:00:00'

D.SET UNTIL TIME '2023-10-10:10:00:00'

AnswerD

This is the correct syntax for point-in-time recovery.

Why this answer

SET UNTIL TIME is the standard way to define the recovery point.

Practice this question →

MCQeasy

What is the purpose of the 'REPORT OBSOLETE' command?

A.To list backups that exceed the retention policy.

B.To identify corrupted backups.

C.To show the status of the FRA.

D.To delete old backups.

AnswerA

It lists them but does not delete them.

Why this answer

It identifies backups that are no longer needed based on the retention policy.

Practice this question →

MCQmedium

You want to clear all configured RMAN settings back to their default values. Which command do you use?

A.CONFIGURE [parameter] CLEAR

B.DELETE CONFIGURATION

C.RESET ALL

D.CONFIGURE ALL CLEAR

AnswerA

This resets the specified parameter to the default.

Why this answer

CONFIGURE [parameter] CLEAR resets a specific setting to its default.

Practice this question →