OCP Core Administration And Cdb Pdb Architecture — Timed 30 Questions

Question 1

Which view should you query to see the current status of all PDBs in the CDB?

Accepted Answer

DBA_PDBS. DBA_PDBS provides the status of all PDBs in the CDB.

Answer

ALL_PDBS

Answer

V$PDBS

Answer

CDB_PDBS

Question 2

In a 23ai CDB, which view reveals the mapping between PDBs and their associated services?

Accepted Answer

V$SERVICES. V$SERVICES shows the service name and the associated PDB ID.

Answer

DBA_SERVICES

Answer

CDB_SERVICES

Answer

V$PDBS

Question 3

In a 23ai CDB, which command enables the automatic creation of PDBs when a non-CDB is plugged in?

Accepted Answer

CREATE PLUGGABLE DATABASE ... AS CLONE. The ADAPTIVE_PDB_CLONING feature or specific metadata handling is used, but standard unplug/plug remains manual.

Answer

ENABLE_AUTO_PLUG

Answer

AUTOCREATE_PDB

Answer

CONFIGURE_AUTO_PDB

Question 4

You are troubleshooting a performance issue where background processes in a PDB are being throttled. You suspect an issue with the Resource Manager plan. How do you verify the current plan for a specific PDB?

Accepted Answer

Check V$CONTAINER_RESOURCE_PLAN. The current resource manager plan is stored in the V$CONTAINER_RESOURCE_PLAN view, which shows the plan associated with the container.

Answer

Check V$SYSTEM_PARAMETER

Answer

Check DBA_PDBS

Answer

Check V$RESOURCE_LIMIT

Question 5

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 6

What is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?

Accepted Answer

MOUNTED. By default, a new PDB is created in MOUNTED state.

Answer

READ WRITE

Answer

OPEN UPGRADE

Answer

READ ONLY

Question 7

A PDB is in 'READ WRITE' mode. You need to perform a maintenance task that requires the PDB to be in 'RESTRICTED' mode. Which command achieves this?

Accepted Answer

ALTER PLUGGABLE DATABASE PDB1 CLOSE IMMEDIATE; ALTER PLUGGABLE DATABASE PDB1 OPEN RESTRICTED;. To move a PDB into restricted mode, you must use ALTER PLUGGABLE DATABASE ... CLOSE followed by OPEN RESTRICTED.

Answer

ALTER SYSTEM SET RESTRICTED_SESSION=TRUE;

Answer

ALTER PLUGGABLE DATABASE PDB1 UPGRADE;

Answer

ALTER DATABASE PDB1 RESTRICTED;

Answer

ALTER PLUGGABLE DATABASE PDB1 OPEN RESTRICTED

Question 8

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 9

When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?

Accepted Answer

Common users can only be created in the root container.. Common users must be created in the root (CDB$ROOT) and local users are specific to individual PDBs.

Answer

Local users are automatically created in all PDBs by default.

Answer

Common users can grant local roles to other common users.

Answer

Local users can grant privileges to common users.

Question 10

You need to migrate a non-CDB database to a PDB in a 23ai CDB. Which utility is the recommended tool to assess compatibility before migration?

Accepted Answer

DBMS_PDB.CHECK_PLUG_COMPATIBILITY. DBMS_PDB.CHECK_PLUG_COMPATIBILITY is the standard PL/SQL procedure to identify potential issues before plugging a non-CDB into a CDB.

Answer

RMAN CONVERT

Answer

DBUA

Answer

SQL Developer

Answer

Data Pump

Question 11

You are configuring a new CDB and want to ensure that PDBs use a common set of initialization parameters while allowing for specific overrides. Which parameter must be configured at the CDB level to allow local PDB parameter overrides?

Accepted Answer

PDB_SPFILE. The PDB_SPFILE parameter in the CDB root allows managing individual PDB spfiles.

Answer

CONTAINER_DATA

Answer

PDB_FILE_NAME_CONVERT

Answer

CDB_PARAMETER_OVERRIDE

Question 12

You are creating a new PDB from an existing one using the CREATE PLUGGABLE DATABASE command. Which clause must you include to ensure the new PDB has a different name and storage location?

Accepted Answer

FILE_NAME_CONVERT. The CREATE PLUGGABLE DATABASE statement requires the file_name_convert clause to define the directory structure for the new PDB datafiles.

Answer

MOVE DATAFILES

Answer

USING STORAGE MAP

Answer

SNAPSHOT COPY

Question 13

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 14

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 15

Which command is used to move a PDB from one CDB to another without using Data Pump?

Accepted Answer

ALTER PLUGGABLE DATABASE UNPLUG. The unplug/plug method using an XML metadata file is the standard for PDB transport.

Answer

CREATE PDB AS CLONE

Answer

DBMS_PDB.COPY

Answer

MOVE PLUGGABLE DATABASE

Question 16

You want to limit the amount of memory a specific PDB can consume in a CDB. Which parameter should you configure?

Accepted Answer

PDB_SGA_TARGET. The SGA_TARGET at the PDB level is managed via the PDB_SGA_TARGET parameter.

Answer

CONTAINER_MEMORY_LIMIT

Answer

MEMORY_TARGET

Answer

SGA_MAX_SIZE_PDB

Question 17

Which directory contains the Alert log for the CDB?

Accepted Answer

ORACLE_BASE/diag/rdbms/.... The Automatic Diagnostic Repository (ADR) stores all CDB diagnostic information.

Answer

/var/log/oracle

Answer

ORACLE_BASE/admin

Answer

ORACLE_HOME/dbs

Question 18

What happens when you execute 'ALTER PLUGGABLE DATABASE ALL OPEN'?

Accepted Answer

Opens all PDBs in read-write mode. All PDBs in the CDB are opened in READ WRITE mode.

Answer

Opens only PDB$SEED

Answer

Opens all PDBs in read-only mode

Answer

Starts the CDB instance

Question 19

You are configuring a PDB to use Local Undo. What requirement must be met before setting the UNDO_TABLESPACE parameter?

Accepted Answer

The PDB must be closed. The CDB must be in local undo mode, and the PDB must be open in restricted mode or closed.

Answer

The CDB must be in read-only mode

Answer

The CDB must be in ARCHIVELOG mode

Answer

The PDB must be a proxy PDB

Question 20

Which initialization parameter determines the maximum number of PDBs allowed in a CDB?

Accepted Answer

MAX_PDB_CONTAINERS. MAX_PDB_CONTAINERS defines the hard limit for PDBs in a CDB.

Answer

DB_FILES

Answer

PDB_LIMIT

Answer

CONTAINERS_MAX