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

Question 1

Which view displays the PDBs that are currently open in the CDB?

Accepted Answer

V$PDBS. V$PDBS shows the status of all PDBs in the instance.

Answer

V$CONTAINERS

Answer

DBA_PDB_STATUS

Answer

CDB_PDB_STATUS

Question 2

What is the primary benefit of using a 'Proxy PDB'?

Accepted Answer

Accessing remote PDB data. A Proxy PDB allows access to a PDB in a remote CDB.

Answer

Speeding up local backups

Answer

Bypassing security

Answer

Increasing local storage

Question 3

What happens to existing sessions when you issue 'ALTER PLUGGABLE DATABASE PDB1 CLOSE'?

Accepted Answer

Sessions are killed if IMMEDIATE is specified. By default, the command fails if sessions exist unless 'IMMEDIATE' is used.

Answer

Sessions are migrated

Answer

The database waits indefinitely

Answer

Sessions remain active

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

You need to ensure that the PDB name is unique in your network. Which parameter should you check?

Accepted Answer

DB_UNIQUE_NAME. DB_UNIQUE_NAME must be unique across the CDB infrastructure.

Answer

INSTANCE_NAME

Answer

DB_NAME

Answer

PDB_NAME

Question 6

Which command is used to display the current container you are connected to?

Accepted Answer

SHOW CON_NAME. SHOW CON_NAME shows the current container name in SQL*Plus.

Answer

SHOW CDB_NAME

Answer

SHOW CURRENT_PDB

Answer

SELECT CONTAINER FROM DUAL

Question 7

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 8

Which component is responsible for managing background processes across all containers in a CDB?

Accepted Answer

CDB Instance. The instance (CDB root) manages background processes for all containers.

Answer

Shared Service Layer

Answer

Global Process Manager

Answer

PDB Instance

Question 9

You are configuring a PDB. What happens to the PDB if you drop the CDB?

Accepted Answer

All PDBs are dropped. All PDBs are automatically removed when the CDB is dropped.

Answer

PDBs remain as standalone

Answer

PDBs become unusable orphans

Answer

PDBs are migrated to another CDB

Question 10

What is the standard tool to manage CDB/PDB configuration in 23ai?

Accepted Answer

SQL*Plus. SQL*Plus or SQLcl are the standard interfaces for managing CDBs.

Answer

SQL Developer

Answer

Net Manager

Answer

OEM

Question 11

When a PDB is in 'RESTRICTED' mode, which sessions are allowed?

Accepted Answer

Only users with RESTRICTED SESSION. Only users with RESTRICTED SESSION privilege are allowed.

Answer

All users

Answer

No users

Answer

Only SYSDBA

Question 12

Which feature allows you to perform point-in-time recovery for a specific PDB without affecting others?

Accepted Answer

RMAN PDB PITR. RMAN PDB-level point-in-time recovery is supported.

Answer

Flashback Database

Answer

PDB Flashback

Answer

Full Database Recovery

Question 13

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 14

You need to monitor wait events for a specific PDB. Which view is most appropriate?

Accepted Answer

V$SESSION. V$SESSION filtered by CON_ID allows viewing PDB-specific sessions.

Answer

V$PDB_WAIT

Answer

V$SYSTEM_EVENT

Answer

DBA_WAIT_EVENTS

Question 15

Which TWO tasks are required to successfully unplug a PDB?

Accepted Answer

Generate an XML metadata file. You must close the PDB and then execute the UNPLUG command.

Answer

Convert to non-CDB

Answer

Drop the PDB

Answer

Shut down the CDB