OCP Backup And Recovery Practice Test 4 — 15 Questions

Question 1

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

Accepted Answer

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

Answer

It validates the backup.

Answer

It encrypts the backup.

Answer

It speeds up the backup.

Question 2

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

Accepted Answer

Perform RECOVER DATABASE USING BACKUP CONTROLFILE.. You need to restore, mount, and recover.

Answer

Delete all existing archivelogs.

Answer

Open the database resetlogs.

Question 3

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

Accepted Answer

Block Change Tracking must be enabled.. BCT must be enabled and an incremental backup must be performed.

Answer

The database must be in restricted mode.

Answer

The database must be in ARCHIVELOG mode.

Answer

Flashback Database must be enabled.

Question 4

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

Accepted Answer

CONFIGURE RETENTION POLICY. CONFIGURE RETENTION POLICY defines the criteria for what is obsolete.

Answer

CONFIGURE AUTO DELETE ON

Answer

SET RETENTION POLICY

Answer

CONFIGURE OBSOLETE ON

Question 5

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

Accepted Answer

The current working directory of the RMAN session.. 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.

Answer

The system tablespace.

Answer

The database home directory.

Answer

The redo log path.

Question 6

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

Accepted Answer

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

Answer

REPORT NEED BACKUP

Answer

LIST FILE

Answer

VALIDATE DATABASE

Question 7

Which RMAN command is used to start an RMAN session?

Accepted Answer

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

Answer

run rman

Answer

start rman

Answer

sqlplus rman

Question 8

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

Accepted Answer

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

Answer

Opening the database with RESETLOGS.

Answer

Performing media recovery.

Question 9

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

Accepted Answer

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

Answer

DELETE CONFIGURATION

Answer

RESET ALL

Answer

CONFIGURE ALL CLEAR

Question 10

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

Accepted Answer

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

Answer

To identify corrupted backups.

Answer

To show the status of the FRA.

Answer

To delete old backups.

Question 11

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

Accepted Answer

BACKUP VALIDATE DATABASE. ANALYZE TABLE and RMAN validate are the primary methods.

Answer

SELECT * FROM V$LOG

Answer

ALTER SYSTEM CHECK

Answer

RECOVER DATABASE

Question 12

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

Accepted Answer

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

Answer

BACKUP CDB PDB pdb_name

Answer

BACKUP DATABASE PDBNAME

Answer

BACKUP PDB ALL

Question 13

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

Accepted Answer

It can be performed on a closed database.. It requires FRA, archivelog mode, and flashback logs.

Answer

It deletes all archivelogs.

Answer

It requires the database to be in open state.

Question 14

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

Accepted Answer

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

Answer

WITH EXTERNAL CONTROLFILE

Answer

RECOVER CONTROLFILE

Answer

USING OLD CONTROLFILE

Question 15

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?

Accepted Answer

The source and target platforms must have the same endian format.. 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.

Answer

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

Answer

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

Answer

The source database must be in restricted mode.