OCP Core Administration And Cdb Pdb Architecture Practice Test 2 — 15 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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

Question 7

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 8

Which privilege is required to perform a PDB unplug operation?

Accepted Answer

SYSDBA. SYSDBA or SYSOPER at the CDB root is required.

Answer

RESOURCE

Answer

CONNECT

Answer

PDB_DBA

Question 9

How can you verify if a PDB is encrypted?

Accepted Answer

Query V$ENCRYPTION_WALLET. Querying DBA_PDB_KE_STATE or checking V$ENCRYPTION_WALLET is the standard method.

Answer

Check PDB_ENCRYPTED column in V$PDBS

Answer

Use SQL*Plus SHOW PARAMETER

Answer

Check the alert log

Question 10

If you want to use a PDB as a template for other PDBs, what state must the template PDB be in?

Accepted Answer

READ ONLY. The PDB must be open in READ ONLY mode to be used as a template.

Answer

MOUNTED

Answer

RESTRICTED

Answer

READ WRITE

Question 11

Which file stores the metadata for a PDB being unplugged?

Accepted Answer

XML file. The unplug process generates an XML file to describe the PDB.

Answer

TXT file

Answer

JSON file

Answer

SQL file

Question 12

You need to capture PDB performance data. Which feature allows you to capture an AWR snapshot for a specific PDB?

Accepted Answer

DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT. DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT is used for AWR snapshots at the container level.

Answer

ALTER PDB SNAPSHOT

Answer

AWR_PDB_SNAPSHOT

Answer

DBMS_PERF.CAPTURE

Question 13

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 14

Which command allows you to change the state of a PDB to READ ONLY?

Accepted Answer

ALTER PLUGGABLE DATABASE OPEN READ ONLY. ALTER PLUGGABLE DATABASE [PDB_NAME] OPEN READ ONLY is the correct syntax.

Answer

OPEN PDB READ ONLY

Answer

ALTER PDB READ ONLY

Answer

ALTER DATABASE PDB OPEN READ ONLY

Question 15

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