20+ practice questions focused on Core Administration And Cdb Pdb Architecture — one of the most tested topics on the Oracle Database 23ai Administrator Professional (OCP, 1Z0-183) (OCP) exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Core Administration And Cdb Pdb Architecture PracticeWhat is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?
Explanation: When you create a pluggable database (PDB) with the CREATE PLUGGABLE DATABASE statement in Oracle Multitenant, the PDB is created in MOUNTED state by default. This means the PDB's data files are associated with the instance, but the PDB is not open for user access. You must explicitly open the PDB with ALTER PLUGGABLE DATABASE ... OPEN to make it available. The MOUNTED state is a transitional state that allows you to perform operations like opening in restricted mode or upgrading before making it available to users.
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?
Explanation: To move a PDB into restricted mode, you must use ALTER PLUGGABLE DATABASE ... CLOSE followed by OPEN RESTRICTED.
When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?
Explanation: Option A is correct because common users are defined once in the root container (CDB$ROOT) and are then visible across all containers, so they must be created while connected to the root. Option D is correct because Oracle enforces that common user names in a CDB begin with the C## (or c##) prefix, which distinguishes them from local users. Option B is wrong because local users exist only in the specific PDB where they are created, not automatically in all PDBs. Option C is wrong because local roles belong to a single PDB and cannot be granted to common users, who operate across containers. Option E is wrong because local users cannot grant privileges to common users; privilege grants involving common users must be performed by appropriately privileged common users in the root.
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?
Explanation: The PDB_SPFILE parameter in the CDB root allows managing individual PDB spfiles.
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?
Explanation: The CREATE PLUGGABLE DATABASE statement requires the file_name_convert clause to define the directory structure for the new PDB datafiles.
+15 more Core Administration And Cdb Pdb Architecture questions available
Practice all Core Administration And Cdb Pdb Architecture questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Core Administration And Cdb Pdb Architecture. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Core Administration And Cdb Pdb Architecture questions on the OCP frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Core Administration And Cdb Pdb Architecture is tested as part of the Oracle Database 23ai Administrator Professional (OCP, 1Z0-183) (OCP) blueprint. Practicing with targeted Core Administration And Cdb Pdb Architecture questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free OCP practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Core Administration And Cdb Pdb Architecture is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Core Administration And Cdb Pdb Architecture practice session with instant scoring and detailed explanations.
Start Core Administration And Cdb Pdb Architecture Practice →