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.

Practise Oracle Database 23ai Administrator Professional (OCP, 1Z0-183) (OCP) Core Administration And Cdb Pdb Architecture practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

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.

Reviewed byJohnson Ajibi· MSc IT Security

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

Core Administration And Cdb Pdb Architecture questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Core Administration And Cdb Pdb Architecture exam traps

▸Answering from memory before reading the full scenario.
▸Missing a constraint such as cost, availability, security, scope or command context.
▸Choosing a broad answer when the question asks for the most specific fix.
▸Ignoring why the wrong options are tempting.

Practice set

Core Administration And Cdb Pdb Architecture questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice

Read the full Core Administration And Cdb Pdb Architecture explanation →

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

Trap 1: ALL_PDBS

This view does not exist.

Trap 2: V$PDBS

This view shows current instance-specific PDB info, but DBA_PDBS is standard for configuration.

Trap 3: CDB_PDBS

This view is not used for status.

Study all Core Administration And Cdb Pdb Architecture common traps →

A
ALL_PDBS
Why wrong: This view does not exist.
B
DBA_PDBS
DBA_PDBS lists all PDBs and their open states.
C
V$PDBS
Why wrong: This view shows current instance-specific PDB info, but DBA_PDBS is standard for configuration.
D
CDB_PDBS
Why wrong: This view is not used for status.

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

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

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

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

Which THREE states can a PDB reside in?

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?

Which view provides information about the open status of all PDBs in a CDB?

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?

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?

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

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?

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?

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

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

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?

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

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

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

23ai New Features practice questions

Core Administration And Cdb Pdb Architecture practice questions

Backup And Recovery practice questions

Security And Upgrades 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