OCP Practice Test 16 — 15 Questions

Question 1

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

Accepted Answer

VALIDATE BACKUPSET. VALIDATE BACKUPSET checks the integrity of the backup pieces.

Answer

LIST BACKUP

Answer

CROSSCHECK BACKUP

Answer

RESTORE DATABASE VALIDATE

Question 2

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

Accepted Answer

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

Answer

It requires less network bandwidth.

Answer

It does not require a connection to the target.

Answer

It creates a backup of the source during duplication.

Question 3

You are tuning a query that is performing poorly due to high 'buffer busy waits'. What is the likely cause?

Accepted Answer

Multiple sessions accessing the same blocks. Buffer busy waits occur when multiple sessions try to modify the same block at the same time.

Answer

PGA memory exhausted

Answer

Library cache contention

Answer

Excessive disk I/O

Question 4

Which dictionary view tracks the PDB creation time?

Accepted Answer

CDB_PDBS. CDB_PDBS contains the creation time of all PDBs in the CDB.

Answer

DBA_PDB_HISTORY

Answer

DBA_OBJECTS

Answer

V$PDBS

Question 5

Which parameter defines the location of the PDB metadata files during a plug operation?

Accepted Answer

PDB_FILE_NAME_CONVERT. The file_name_convert parameter or explicit pathing is used.

Answer

DB_CREATE_FILE_DEST

Answer

DATA_FILE_DIR

Answer

FILE_NAME_DIR

Question 6

When using parallel DML, which system parameter limits the degree of parallelism?

Accepted Answer

PARALLEL_DEGREE_LIMIT. PARALLEL_DEGREE_LIMIT restricts the degree of parallelism.

Answer

MAX_PARALLEL_THREADS

Answer

DB_PARALLEL_LIMIT

Answer

SESSION_PARALLEL_MAX

Question 7

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

Accepted Answer

To perform the recovery of the target tablespaces.. 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.

Answer

To act as a standby database.

Answer

To host the recovery catalog.

Answer

To manage the control file backups.

Question 8

Which procedure in the DBMS_SPM package is used to evolve a SQL plan baseline?

Accepted Answer

DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE. DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE is the standard procedure to evolve baselines.

Answer

DBMS_SPM.DROP_SQL_PLAN_BASELINE

Answer

DBMS_SPM.ALTER_SQL_PLAN_BASELINE

Answer

DBMS_SPM.LOAD_PLANS_FROM_SQLSET

Question 9

Which view provides information about the open status of all PDBs in a CDB?

Accepted Answer

V$PDBS. V$PDBS provides the current status of each PDB in the container database.

Answer

V$INSTANCE

Answer

V$CONTAINERS

Answer

V$DATABASE

Answer

DBA_PDBS

Question 10

When performing a 'Refreshable PDB Switchover', what is the state of the source PDB?

Accepted Answer

READ ONLY. During a switchover, the source PDB is converted to a refreshable PDB.

Answer

RESTRICTED

Answer

READ WRITE

Answer

MOUNTED

Question 11

What is the purpose of the 'CDB_ROOT'?

Accepted Answer

To store system metadata. The CDB root manages system-wide objects and metadata.

Answer

To store PDB$SEED

Answer

To store user data

Answer

To manage PDB recovery

Question 12

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 13

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?

Accepted Answer

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

Answer

RECOVER DATABASE TEST;

Answer

CHECK DATAFILES;

Answer

RESTORE DATABASE VALIDATE;

Question 14

What is the primary function of ADDM in Oracle Database 23ai?

Accepted Answer

To identify performance bottlenecks and provide recommendations. ADDM analyzes AWR snapshots to identify performance bottlenecks and provide recommendations.

Answer

To capture SQL execution plans

Answer

To migrate data between instances

Answer

To automatically tune individual SQL statements

Question 15

An administrator has been tasked with reducing the overhead of AWR snapshot collection. What is the most effective way to modify the snapshot interval?

Accepted Answer

Use the DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS procedure.. The DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS procedure is the official method to adjust snapshot frequency and retention policies.

Answer

Edit the SPFILE to change the statistics_level to 'BASIC'.

Answer

Update the SGA_TARGET parameter.

Answer

Manually delete old records from the DBA_HIST_SNAPSHOT view.