1Z0-006 Oracle Architecture & Tools 2 — Questions and Answers
Question 1: Which Oracle background process is responsible for writing dirty buffers from the buffer cache to data files?
- LGWR
- DBWR (Correct answer)
- SMON
- PMON
Correct answer: DBWR
DBWR (Database Writer) moves modified (dirty) buffers from the buffer cache to the physical data files on disk.
Question 2: What is the purpose of the Oracle Redo Log Buffer?
- Stores recently executed SQL statements
- Holds redo entries before they are written to redo log files (Correct answer)
- Caches data blocks read from disk
- Stores parsed SQL execution plans
Correct answer: Holds redo entries before they are written to redo log files
The Redo Log Buffer is a circular buffer in the SGA that holds redo entries (change vectors) before LGWR flushes them to the online redo log files.
Question 3: Which Oracle tool provides a graphical interface for database administration including startup, shutdown, and performance monitoring?
- SQL*Plus
- SQL Developer
- Enterprise Manager Database Express (Correct answer)
- RMAN
Correct answer: Enterprise Manager Database Express
Oracle Enterprise Manager Database Express is the web-based GUI tool bundled with Oracle Database for administration tasks like startup/shutdown, storage, and performance.
Question 4: What does the Oracle PMON background process do?
- Writes redo log buffers to disk
- Cleans up failed user process resources and rolls back uncommitted transactions (Correct answer)
- Manages checkpoints and synchronizes data files
- Archives filled online redo log files
Correct answer: Cleans up failed user process resources and rolls back uncommitted transactions
PMON (Process Monitor) detects failed user processes and cleans up resources such as locks, releasing them and rolling back uncommitted transactions.
Question 5: In Oracle, what is the Shared Pool primarily used for?
- Storing data blocks recently read from disk
- Caching parsed SQL and PL/SQL code along with data dictionary information (Correct answer)
- Buffering redo entries before writing to log files
- Holding sort operations that exceed memory
Correct answer: Caching parsed SQL and PL/SQL code along with data dictionary information
The Shared Pool stores the Library Cache (parsed SQL/PL/SQL) and the Data Dictionary Cache (metadata), allowing reuse of parsed statements.
Question 6: Which Oracle utility is a command-line tool used specifically for backup and recovery operations?
- SQL*Plus
- Data Pump
- RMAN (Correct answer)
- ADDM
Correct answer: RMAN
RMAN (Recovery Manager) is Oracle's dedicated command-line utility for backup, restore, and recovery of Oracle databases.
Question 7: What is an Oracle Instance?
- The physical database files stored on disk
- The combination of memory structures and background processes that manage the database (Correct answer)
- A single user session connected to the database
- The control file that tracks database structure
Correct answer: The combination of memory structures and background processes that manage the database
An Oracle Instance consists of the SGA (memory) and the set of background processes; it provides access to the database but is distinct from the database files themselves.
1Z0-006 Oracle Architecture & Tools 2
Which Oracle background process is responsible for writing dirty buffers from the buffer cache to data files?