Oracle
1Z0-062 · Question #177
1Z0-062 Question #177: Real Exam Question with Answer & Explanation
The correct answer is C: The command will, create a common user whose description is contained in the root and each. This question tests how Oracle common users behave across a CDB and its PDBs when created with CONTAINER=ALL. Understanding schema visibility and object scope differences between containers is key.
Question
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?
Exhibit
Options
- ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
- BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
- CThe command will, create a common user whose description is contained in the root and each
- DThe schema for the common user C # # A_ADMIN can be different in each container.
- EThe command will create a user in the root container only because the container clause is not
Explanation
This question tests how Oracle common users behave across a CDB and its PDBs when created with CONTAINER=ALL. Understanding schema visibility and object scope differences between containers is key.
Common mistakes.
- A. Schema objects owned by a common user are not automatically shared across PDBs - they exist only in the specific container where they were created, and each PDB maintains its own independent set of schema objects for that user.
- B. When CONTAINER=ALL is used, the temporary tablespace assignment applies across all containers, not just the root - the user can use TEMP_TS in any PDB where that tablespace exists or is mapped.
- E. Omitting the CONTAINER clause defaults to CONTAINER=ALL for common users (whose names must begin with C##), so the user is created in root and all PDBs, not only in root.
Concept tested. Oracle CDB common user creation and scope
Community Discussion
No community discussion yet for this question.