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

Database Architecture Flashcards

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

  1. Which component of the Oracle Database architecture is responsible for managing memory structures and background processes?

    Answer: Oracle Instance

    The Oracle Instance is the combination of memory structures (like the SGA and PGA) and background processes that manage the database. It is the active component that runs when the database is started, handling all operations related to memory allocation, process management, and interaction with the database files. Datafiles, Control Files, and Tablespaces are physical storage components, not the managing entity.

  2. What is the primary function of the System Global Area (SGA) in the Oracle Database architecture?

    Answer: Containing shared memory structures for caching data and control information

    The System Global Area (SGA) is a shared memory region allocated by Oracle when the instance starts. Its primary function is to store shared memory structures like the Buffer Cache, Shared Pool, and Redo Log Buffer. These structures are crucial for caching frequently accessed data, SQL statements, and transaction information to significantly improve database performance.

  3. Which of the following is NOT a component of the SGA in Oracle Database?

    Answer: PGA (Program Global Area)

    The PGA (Program Global Area) is a memory region allocated to each server process or background process, containing data and control information specific to that process. Unlike the SGA, which is a shared memory area accessible by all processes, the PGA is private to a single process and therefore not a component of the shared System Global Area.

  4. What is the purpose of Oracle's Control File?

    Answer: To maintain the metadata of the database's physical structure

    The control file is a small, binary file essential for the operation of an Oracle database. It contains critical metadata such as the database name, the names and locations of datafiles and redo log files, and checkpoint information. Oracle uses this metadata to open and maintain the database's physical structure, making it vital for database consistency and recovery.

  5. Which Oracle background process is responsible for writing the contents of the Redo Log Buffer to the redo log files?

    Answer: LGWR (Log Writer)

    The LGWR (Log Writer) background process is specifically responsible for writing the contents of the Redo Log Buffer to the online redo log files on disk. This process is critical for ensuring data durability and recovery, as it records all changes made to the database before they are permanently written to datafiles.