1Z0-006 Oracle Architecture & Tools 4 — Questions and Answers
Question 1: What happens to the Program Global Area (PGA) when a user session terminates?
- It is moved to the Shared Pool for reuse by other sessions
- It is written to a temp file for recovery purposes
- It is deallocated and the memory is returned to the OS (Correct answer)
- It remains allocated until the next checkpoint
Correct answer: It is deallocated and the memory is returned to the OS
PGA memory is private to each server process; when that process ends (session terminates), its PGA is freed back to the operating system.
Question 2: Which Oracle background process performs instance recovery automatically when the database is restarted after a crash?
- PMON
- DBWR
- SMON (Correct answer)
- LGWR
Correct answer: SMON
SMON (System Monitor) performs instance recovery at startup by applying redo logs to roll forward and then rolling back uncommitted transactions.
Question 3: What is the role of the Control File in an Oracle database?
- Stores redo information for transaction recovery
- Contains the binary record of the database structure including data file locations and log file history (Correct answer)
- Holds the parameter settings used at instance startup
- Stores the compiled PL/SQL code for stored procedures
Correct answer: Contains the binary record of the database structure including data file locations and log file history
The control file is a small binary file that records the database name, data file and redo log locations, checkpoint information, and RMAN backup history.
Question 4: In Oracle, what is Automatic Memory Management (AMM)?
- A feature where Oracle automatically manages OS swap space
- A mode where Oracle automatically distributes memory between SGA and PGA based on workload (Correct answer)
- A method of automatically compressing data files to save disk space
- An Oracle feature that automatically extends tablespace when full
Correct answer: A mode where Oracle automatically distributes memory between SGA and PGA based on workload
AMM allows Oracle to automatically tune the total memory (SGA + PGA) allocation between components based on current workload demand.
Question 5: Which file type stores the actual table rows and index data in an Oracle database?
- Control files
- Redo log files
- Data files (Correct answer)
- Parameter files (SPFILE)
Correct answer: Data files
Data files (.dbf) store the actual user data including table rows, index entries, and other database object data.
Question 6: What is the purpose of the SPFILE (Server Parameter File) in Oracle?
- Records the sequence of all transactions for recovery
- Stores database initialization parameters persistently in binary format on the server (Correct answer)
- Contains the mapping between logical tablespaces and physical data files
- Tracks all user sessions currently connected to the database
Correct answer: Stores database initialization parameters persistently in binary format on the server
The SPFILE is a binary server-side file that persistently stores initialization parameters; changes made with ALTER SYSTEM persist across restarts.
Question 7: Oracle Data Pump (expdp/impdp) is used for which primary purpose?
- Real-time replication of data to a standby database
- High-speed export and import of database objects and data (Correct answer)
- Compressing and archiving redo log files
- Monitoring and tuning SQL execution plans
Correct answer: High-speed export and import of database objects and data
Oracle Data Pump provides fast, parallel export (expdp) and import (impdp) of database schemas, tables, and data using a proprietary binary format.
1Z0-006 Oracle Architecture & Tools 4
What happens to the Program Global Area (PGA) when a user session terminates?