Practice Test Geeks(1Z0-006) Oracle Database Foundations Associate Practice Test
← All 1Z0-006 Flashcard Decks

Oracle Database Architecture Flashcards

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

Read the first 7 Oracle Database Architecture flashcards as text

  1. What is the purpose of the SYSTEM tablespace in an Oracle database?

    Answer: Holding the data dictionary and core internal Oracle objects

    The SYSTEM tablespace is mandatory and stores the data dictionary, PL/SQL source code, and internal Oracle objects that the database needs to function.

  2. In Oracle's memory architecture, which area is shared by all sessions connected to the same instance?

    Answer: SGA (System Global Area)

    The SGA is a shared memory region allocated when the instance starts and is accessible by all background and server processes of that instance.

  3. Which Oracle shutdown mode waits for all current transactions to complete before shutting down?

    Answer: SHUTDOWN TRANSACTIONAL

    SHUTDOWN TRANSACTIONAL waits for all active transactions to either commit or roll back before disconnecting sessions and shutting down the database.

  4. What is a schema in Oracle database terminology?

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

    A schema is a logical collection of database objects—tables, views, indexes, procedures, etc.—owned by and associated with a particular database user.

  5. Which Oracle feature allows a single physical database to be presented as multiple logical databases to different applications?

    Answer: Pluggable Databases (PDB) in Multitenant architecture

    Oracle Multitenant architecture uses a Container Database (CDB) to host multiple Pluggable Databases (PDBs), each appearing as an independent database.

  6. What does the LREG (Listener Registration) process do in Oracle 12c and later?

    Answer: Registers instance and dispatcher information with the Oracle listener

    LREG dynamically registers the instance's services, database name, and dispatcher information with the Oracle Net listener so clients can connect.

  7. When Oracle performs a full checkpoint, which processes are directly involved?

    Answer: DBWn writes all dirty buffers to disk, and CKPT updates data file headers and the control file

    During a full checkpoint, DBWn flushes all dirty buffers from the buffer cache to data files, and CKPT updates the data file headers and control file with the new checkpoint SCN.