Practice Test Geeks(OCP) Oracle Certified Professional Practice Test
← All OCP Flashcard Decks

Database Architecture & Configuration Flashcards

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

Read the first 7 Database Architecture & Configuration flashcards as text

  1. In Oracle's multi-tenant architecture, which container stores the data dictionary for all PDBs within the CDB?

    Answer: CDB$ROOT

    CDB$ROOT contains the common data dictionary (system metadata) shared across the entire CDB, while each PDB maintains its local application data dictionary.

  2. What does it mean for an Oracle tablespace to be in 'read-only' mode?

    Answer: No DML or DDL can modify objects in the tablespace, but queries are permitted

    A read-only tablespace allows SELECT queries but prevents any INSERT, UPDATE, DELETE, or DDL operations that would modify its contents.

  3. Which Oracle feature allows a single database instance to host multiple schemas that appear as separate databases to application users?

    Answer: Multitenant / Pluggable Databases (PDB)

    Oracle Multitenant architecture allows multiple Pluggable Databases (PDBs) within one Container Database (CDB), each appearing as an independent database to connected applications.

  4. What happens to the PGA (Program Global Area) when a user session ends?

    Answer: It is deallocated and its memory is returned to the OS or Oracle PGA pool

    PGA memory is private to each server process and is deallocated when the associated session terminates, returning memory to the available pool.

  5. Which Oracle initialization parameter specifies the maximum number of simultaneously open cursors per session?

    Answer: OPEN_CURSORS

    OPEN_CURSORS sets the maximum number of open cursors (context areas) a single session can have simultaneously, helping prevent runaway cursor leaks.

  6. In Oracle Database, what is an 'extent' in the storage hierarchy?

    Answer: A contiguous set of Oracle blocks allocated as a unit to a segment

    An extent is a contiguous allocation of a specific number of Oracle data blocks, and segments grow by acquiring additional extents.

  7. What is the primary purpose of the Oracle 'flashback' technology at the database level?

    Answer: To allow the database to be rewound to a previous point in time without restoring from backup

    Oracle Flashback Database uses flashback logs to quickly rewind the entire database to a past SCN or timestamp without needing a full RMAN restore.