Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Multitenant Architecture Flashcards

7 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Multitenant Architecture flashcards as text

  1. What does CDB stand for in Oracle Multitenant Architecture?

    Answer: Container Database

    CDB stands for Container Database, which is the top-level database that can hold multiple Pluggable Databases (PDBs).

  2. What is the name of the root container in a CDB?

    Answer: CDB$ROOT

    The root container is always named CDB$ROOT and holds Oracle-supplied metadata, common users, and common roles.

  3. What is the primary purpose of PDB$SEED in a CDB?

    Answer: It serves as a read-only template for creating new PDBs

    PDB$SEED is a read-only seed PDB that Oracle uses as a template when creating new pluggable databases.

  4. Which dynamic performance view shows ALL containers in a CDB, including CDB$ROOT and PDB$SEED?

    Answer: V$CONTAINERS

    V$CONTAINERS includes every container (CDB$ROOT, PDB$SEED, and all user-created PDBs), while V$PDBS shows only PDBs.

  5. Which SQL statement switches the current session from CDB$ROOT to a specific PDB?

    Answer: ALTER SESSION SET CONTAINER = pdb_name

    ALTER SESSION SET CONTAINER = pdb_name switches the current session context to the specified PDB without disconnecting.

  6. What is a 'common user' in Oracle Multitenant Architecture?

    Answer: A user created in CDB$ROOT that exists across all containers

    A common user is defined in CDB$ROOT and automatically has a presence in every container, including PDB$SEED and all PDBs.

  7. What naming convention is required for common users created in a CDB?

    Answer: Names must begin with the prefix C##

    Common user names must start with C## (e.g., C##ADMIN) by default to distinguish them from local users scoped to a single PDB.