OCP Practice Test 17 — 15 Questions

Question 1

A DBA needs to identify which PDBs are currently using more than their allocated TEMP tablespace quota. Which view should be queried?

Accepted Answer

V$PDB_TEMP_SPACE_USAGE. V$TEMP_SPACE_HEADER and V$TEMPSEG_USAGE are standard, but V$PDB_TEMP_SPACE_USAGE provides the specific view for monitoring PDB-level temporary tablespace usage.

Answer

DBA_TEMP_FILES

Answer

V$SESSTAT

Answer

DBA_USERS

Question 2

Which THREE features are required for using Flashback Database?

Accepted Answer

A Fast Recovery Area (FRA) must be configured.. Flashback Database requires the recovery area, flashback logs, and the database to be in ARCHIVELOG mode.

Answer

The database must be in NOARCHIVELOG mode.

Answer

The database must be a standby.

Question 3

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

Accepted Answer

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

Answer

BACKUP DATABASE IGNORE READONLY

Answer

BACKUP DATABASE EXCEPT READONLY

Answer

CONFIGURE EXCLUDE READONLY ON

Question 4

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

Accepted Answer

LIST BACKUP. LIST BACKUP is the standard command for this.

Answer

REPORT BACKUP

Answer

SHOW BACKUP

Answer

DISPLAY BACKUP

Question 5

To improve performance, you suspect an index is missing. Which advisor should you invoke to get recommendations for new indexes?

Accepted Answer

SQL Access Advisor. The SQL Access Advisor provides recommendations on schema design, including indexes and materialized views.

Answer

SQL Tuning Advisor

Answer

Memory Advisor

Answer

ADDM

Question 6

You need to migrate a non-CDB to a PDB in an existing CDB. Which package should you use to check for compatibility issues before starting the migration?

Accepted Answer

DBMS_PDB.CHECK_PLUG_COMPATIBILITY. DBMS_PDB.CHECK_PLUG_COMPATIBILITY is the standard procedure for pre-migration validation.

Answer

DBMS_PDB_MIGRATE

Answer

DBMS_METADATA.CHECK

Answer

DBMS_CDB_UPGRADE

Question 7

What is the purpose of the 'Seed' PDB (PDB$SEED)?

Accepted Answer

To act as a template for new PDBs. PDB$SEED is the template for creating new PDBs.

Answer

To store undo data

Answer

To hold CDB diagnostic logs

Answer

To store temporary data

Question 8

What is the default behavior when shutting down a CDB instance?

Accepted Answer

Closes all PDBs, then the CDB. The SHUTDOWN command closes all PDBs before the CDB.

Answer

Leaves PDBs open

Answer

Only closes the CDB root

Answer

Forces immediate abort

Question 9

When using 'Snapshot Carousel', how many snapshots can a single PDB retain?

Accepted Answer

Defined by MAX_PDB_SNAPSHOTS. The number is managed by the MAX_PDB_SNAPSHOTS parameter.

Answer

Fixed at 8

Answer

Controlled by the OS

Answer

Unlimited

Question 10

You need to create a PDB from a remote PDB. Which clause must be included in the CREATE PLUGGABLE DATABASE command?

Accepted Answer

FROM ...@dblink. The FROM clause with a database link is required for remote cloning.

Answer

SOURCE ...@dblink

Answer

USING ...@dblink

Answer

REMOTE ...@dblink

Question 11

Which TWO views are essential for monitoring PDB-specific memory usage?

Accepted Answer

V$PDB_MEMORY. V$PDB_MEMORY and V$RESOURCE_LIMIT allow tracking PDB memory consumption.

Answer

V$SGA_DYNAMIC_COMPONENTS

Answer

V$PDB_WAIT_EVENTS

Answer

V$MEMORY_TARGET

Question 12

Which TWO actions are required when performing a 'Unplug and Plug' operation of a PDB between two different CDBs to ensure data integrity?

Accepted Answer

An XML metadata file must be created during the unplug process. To safely move a PDB, the database must be in a consistent state (closed) and the metadata XML file must be generated to describe the PDB structures.

Answer

The PDB must be opened in upgrade mode before unplugging

Answer

The source CDB must be dropped after the operation

Answer

The CDB must be in restricted mode

Question 13

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

Accepted Answer

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

Answer

DROP BACKUP

Answer

PURGE BACKUPS

Answer

DELETE BACKUP

Question 14

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

Accepted Answer

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

Answer

CONFIGURE MAXPIECESIZE

Answer

SET BACKUPPIECE SIZE

Answer

CONFIGURE CHANNEL MAXSIZE

Question 15

Which RMAN command displays the database structure and associated datafiles?

Accepted Answer

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

Answer

DESCRIBE DATABASE

Answer

LIST SCHEMA

Answer

SHOW SCHEMA