1Z0-006 Oracle Database Architecture 5 — Questions and Answers
Question 1: What is the purpose of the SYSTEM tablespace in an Oracle database?
- Storing temporary sort results for user queries
- Holding the data dictionary and core internal Oracle objects (Correct answer)
- Archiving old redo log files
- Providing undo storage for all user transactions
Correct 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.
Question 2: In Oracle's memory architecture, which area is shared by all sessions connected to the same instance?
- PGA (Program Global Area)
- UGA (User Global Area) in dedicated mode
- SGA (System Global Area) (Correct answer)
- Sort work area
Correct 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.
Question 3: Which Oracle shutdown mode waits for all current transactions to complete before shutting down?
- SHUTDOWN ABORT
- SHUTDOWN IMMEDIATE
- SHUTDOWN TRANSACTIONAL (Correct answer)
- SHUTDOWN NORMAL
Correct answer: SHUTDOWN TRANSACTIONAL
SHUTDOWN TRANSACTIONAL waits for all active transactions to either commit or roll back before disconnecting sessions and shutting down the database.
Question 4: What is a schema in Oracle database terminology?
- A physical storage structure on disk
- A collection of database objects owned by a specific user (Correct answer)
- A background process group
- A named set of redo log files
Correct 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.
Question 5: Which Oracle feature allows a single physical database to be presented as multiple logical databases to different applications?
- Tablespace encryption
- Pluggable Databases (PDB) in Multitenant architecture (Correct answer)
- Data file multiplexing
- Undo tablespace segmentation
Correct 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.
Question 6: What does the LREG (Listener Registration) process do in Oracle 12c and later?
- Logs failed login attempts to the audit trail
- Registers instance and dispatcher information with the Oracle listener (Correct answer)
- Manages large object (LOB) segments in tablespaces
- Synchronizes redo log buffers across RAC nodes
Correct 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.
Question 7: When Oracle performs a full checkpoint, which processes are directly involved?
- Only LGWR writes redo entries and closes the log group
- DBWn writes all dirty buffers to disk, and CKPT updates data file headers and the control file (Correct answer)
- SMON rolls back all uncommitted transactions to ensure consistency
- ARCn copies the redo log and PMON updates the SGA
Correct 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.
1Z0-006 Oracle Database Architecture 5
What is the purpose of the SYSTEM tablespace in an Oracle database?