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. Which Oracle memory structure caches the parsed representations of SQL statements and PL/SQL code?

    Answer: Library cache (within the shared pool)

    The library cache, a component of the shared pool, stores parsed SQL cursors and execution plans to enable soft parses.

  2. When using Automatic Memory Management (AMM), which two parameters must be set and which must be zeroed out?

    Answer: Set MEMORY_TARGET and MEMORY_MAX_TARGET; set SGA_TARGET and PGA_AGGREGATE_TARGET to 0

    AMM requires MEMORY_TARGET (and optionally MEMORY_MAX_TARGET) to be set while SGA_TARGET and PGA_AGGREGATE_TARGET must be 0 to allow full automatic management.

  3. What is the role of the SMON background process in Oracle Database?

    Answer: Performs instance recovery at startup and coalesces free space in tablespaces

    SMON performs crash/instance recovery during startup and reclaims temporary segments and coalesces free dictionary-managed tablespace extents.

  4. Which type of Oracle tablespace is used to store temporary segments for operations like sorting and hashing?

    Answer: TEMP tablespace

    A TEMP (temporary) tablespace stores transient work segments for SQL operations that exceed PGA memory, such as large sorts.

  5. In Oracle, what is a 'segment' in storage architecture terms?

    Answer: A database object that consumes storage (e.g., a table, index, or undo segment)

    A segment is any database object that occupies physical storage, such as a table segment, index segment, or rollback segment.

  6. What does the DB_BLOCK_SIZE parameter define, and when must it be set?

    Answer: Size of the standard Oracle database block; set at database creation and cannot be changed

    DB_BLOCK_SIZE defines the standard block size for the database and is fixed at creation time — changing it requires recreating the database.

  7. Which Oracle file contains the database name, DBID, and locations of all datafiles and redo logs?

    Answer: Control file

    The control file stores critical database structural information including the database name, DBID, datafile/redo log locations, and checkpoint information.