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

Database Architecture & Administration 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 & Administration flashcards as text

  1. In Oracle, what is the role of the ARCH (Archiver) background process?

    Answer: Copies full online redo log files to archive destinations

    ARCH copies filled online redo log files to one or more archive destinations, enabling media recovery of the database.

  2. Which Oracle initialization parameter specifies the size of the System Global Area (SGA) as a whole, allowing Oracle to automatically distribute memory among SGA components?

    Answer: SGA_TARGET

    SGA_TARGET enables Automatic Shared Memory Management (ASMM), letting Oracle automatically tune SGA component sizes within the specified total.

  3. What is a 'hot backup' (also called an online backup) in Oracle?

    Answer: A backup taken while the database is open and processing transactions

    A hot backup (online backup) is performed while the database is open and available to users, requiring the database to be in ARCHIVELOG mode.

  4. Which Oracle view shows the current status and mode of all online redo log groups?

    Answer: V$LOG

    V$LOG displays information about online redo log groups including their status (CURRENT, ACTIVE, INACTIVE) and whether they need archiving.

  5. In Oracle, what is a 'schema' in the context of database architecture?

    Answer: A collection of database objects owned by a specific database user

    A schema is a logical collection of database objects (tables, indexes, views, etc.) that are owned by and associated with a specific database user.

  6. Which component of Oracle's Program Global Area (PGA) stores bind variable values and the state of a cursor for a specific session?

    Answer: Private SQL area

    The private SQL area within the PGA stores cursor state, bind variable values, and query execution state for each open cursor in a session.

  7. What does the Oracle parameter DB_BLOCK_SIZE determine, and when can it be changed?

    Answer: The standard block size for the database; it can only be set at database creation

    DB_BLOCK_SIZE sets the standard Oracle data block size for the database and can only be specified at database creation time — it cannot be changed afterward.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. oracle.com — Test dates, score release, retake policy · verified Oct 2026
  2. mylearn.oracle.com — Test delivery, exam format, passing score, time limit · verified Oct 2026