OCP · topic practice

Core Administration And Cdb Pdb Architecture practice questions

Q: How should I use these Core Administration And Cdb Pdb Architecture practice questions?

Read each scenario carefully and choose your answer before revealing the explanation. Then check why your choice was right or wrong. Repeat until the reasoning feels automatic.

Q: Can I practise just Core Administration And Cdb Pdb Architecture questions in a focused session?

Yes — use the session launcher on this page to start a 10-, 20-, 30- or 50-question session drawn entirely from the Core Administration And Cdb Pdb Architecture domain.

This domain covers Oracle Database 23ai multitenant administration: CDB and PDB architecture, PDB creation and cloning, open/close and save state, snapshot carousel and PDB snapshots, PDB XML metadata, and lifecycle operations such as unplugging, dropping, and relocating PDBs within or across CDBs.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member

20 questionsDomain: Core Administration And Cdb Pdb Architecture

Practice 10 questions Browse domain →

What the exam tests

What to know about Core Administration And Cdb Pdb Architecture

Be able to create, clone, unplug, plug, open, close, and drop PDBs in a CDB, and manage snapshots and saved state. The critical point: a PDB is fully dependent on its CDB, so dropping the CDB destroys every PDB inside it.

Creating, cloning, plugging, and unplugging PDBs with CREATE PLUGGABLE DATABASE and DBMS_PDB

Managing PDB open modes and saved state via ALTER PLUGGABLE DATABASE and PDB$SAVED_STATE

Using snapshot carousel, MAX_PDBS, and PDB snapshot retention settings

Reading PDB XML metadata and understanding CDB/PDB data dictionary separation

Watch out for

Common Core Administration And Cdb Pdb Architecture exam traps

▸Assuming a PDB survives dropping its CDB; dropping the CDB removes all contained PDBs and their datafiles.
▸Confusing PDB snapshot retention with guaranteed restore points or with the number of PDBs a CDB can hold.
▸Forgetting that closing a PDB for maintenance disconnects sessions, and that RESTRICTED mode affects only new connections.

Practice set

Core Administration And Cdb Pdb Architecture questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

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

Trap 1: READ WRITE

It must be opened manually.

Trap 2: OPEN UPGRADE

This is for maintenance.

Trap 3: READ ONLY

This is not the default.

Study all Core Administration And Cdb Pdb Architecture common traps →

A
MOUNTED
A newly created pluggable database opens in MOUNTED state, not READ WRITE. The CREATE PLUGGABLE DATABASE statement only builds the PDB's data files and registers it in the CDB; you must issue ALTER PLUGGABLE DATABASE ... OPEN to make it accessible. This default satisfies the stem's constraint on the state immediately after creation.
B
READ WRITE
Why it fails: It must be opened manually.
C
OPEN UPGRADE
Why it fails: This is for maintenance.
D
READ ONLY
Why it fails: This is not the default.

Core Administration And Cdb Pdb Architecture practice questions

What to know about Core Administration And Cdb Pdb Architecture

Common Core Administration And Cdb Pdb Architecture exam traps

Core Administration And Cdb Pdb Architecture questions

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

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?

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

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?

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?

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

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

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

Which directory contains the Alert log for the CDB?

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

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

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

Which privilege is required to perform a PDB unplug operation?

How can you verify if a PDB is encrypted?

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

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

What is the purpose of the 'CDB_ROOT'?

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

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

Which dictionary view tracks the PDB creation time?

Track your progress over time

Start a Core Administration And Cdb Pdb Architecture only practice session

Related OCP topic practice pages

Performance Tuning And Diagnostics practice questions

Core Administration And Cdb Pdb Architecture practice questions

23ai New Features practice questions

Security And Upgrades practice questions

Backup And Recovery practice questions

OCP fundamentals practice questions

OCP scenario practice questions

OCP troubleshooting practice questions

Frequently asked questions

Track your progress

Study resources

Exam traps to avoid