OCP Practice Test 5 — 10 Questions

Question 1

You need to ensure that the PDB$SEED template is updated with the latest patch level from the CDB. How should you proceed?

Accepted Answer

Apply the patch to the CDB and let the system handle synchronization. The PDB$SEED is read-only. To update it, you must apply the patch to the CDB home, and the seed will be automatically synchronized during the next CDB startup or via the execution of the datapatch utility.

Answer

Run 'ALTER PLUGGABLE DATABASE PDB$SEED SYNC'

Answer

Drop and recreate PDB$SEED using the CREATE PLUGGABLE DATABASE command

Answer

Open PDB$SEED in READ WRITE mode and apply patches

Question 2

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 3

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?

Accepted Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE SBT;. The CONFIGURE ARCHIVELOG BACKUP COPIED command with the TO DEVICE TYPE and num_copies parameters defines the retention policy for archived logs.

Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

Answer

SET ARCHIVELOG DELETION POLICY TO 2 COPIES;

Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Question 4

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

Accepted Answer

Exporting the recovered table to the target database using Data Pump. 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.

Answer

Automatic deletion of all backups older than the restore point

Answer

Automatic conversion of the database to NOARCHIVELOG mode

Question 5

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?

Accepted Answer

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

Answer

Redo log files

Answer

Parameter files

Answer

Control files

Question 6

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

Accepted Answer

CONFIGURE CONTROLFILE AUTOBACKUP ON. CONFIGURE CONTROLFILE AUTOBACKUP ON enables automatic control file backups.

Answer

BACKUP CONTROLFILE ON

Answer

ALTER SYSTEM SET CONTROLFILE_AUTOBACKUP=TRUE

Answer

SET CONTROLFILE AUTOBACKUP ON

Question 7

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 8

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?

Accepted Answer

The auxiliary instance must have enough disk space to hold the tablespace being recovered.. TSPITR requires an auxiliary instance to recover the tablespace to the desired point in time before importing it back to the target database.

Answer

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

Answer

The auxiliary instance must be configured with a separate ORACLE_HOME.

Answer

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

Question 9

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?

Accepted Answer

BACKUP DATABASE. 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.

Answer

CONFIGURE INCLUDE PDB BACKUP ON

Answer

CONFIGURE CDB BACKUP ALL ON

Answer

BACKUP CONTAINER ALL

Question 10

You want to capture a specific set of SQL statements and their execution plans to baseline them. Which package allows you to capture plans from the cursor cache?

Accepted Answer

DBMS_SPM. DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE is the standard way to load plans into the baseline.

Answer

DBMS_SCHEDULER

Answer

DBMS_SQLTUNE

Answer

DBMS_STATS