1Z0-006 Oracle Architecture & Tools 5 — Questions and Answers
Question 1: What is the difference between a dedicated server and a shared server connection in Oracle?
- Dedicated server uses TCP; shared server uses named pipes
- In dedicated server, each session has its own server process; in shared server, multiple sessions share server processes (Correct answer)
- Dedicated server only supports read-only connections; shared server allows writes
- Shared server stores session state in the SGA; dedicated server stores it in a temp file
Correct answer: In dedicated server, each session has its own server process; in shared server, multiple sessions share server processes
With dedicated server, Oracle spawns one server process per user session; with shared server (MTS), a pool of server processes handles requests from many sessions.
Question 2: Which Oracle network component resolves a service name (like 'ORCL') to a database host, port, and service name?
- Oracle Net Listener
- tnsnames.ora (Correct answer)
- sqlnet.ora
- listener.ora
Correct answer: tnsnames.ora
The tnsnames.ora file contains named connection descriptors that map service aliases to host, port, and Oracle service name for client connections.
Question 3: Which background process writes redo entries from the Redo Log Buffer to the online redo log files?
- DBWR
- CKPT
- LGWR (Correct answer)
- ARCH
Correct answer: LGWR
LGWR (Log Writer) writes redo entries from the in-memory Redo Log Buffer to the online redo log files on disk at commit, every 3 seconds, or when the buffer is 1/3 full.
Question 4: What is an Oracle Service Name used for?
- Identifying a specific background process within an instance
- Providing a logical alias that clients use to connect to a database or specific workload group (Correct answer)
- Naming the physical data files associated with a tablespace
- Labeling archived redo log files for recovery identification
Correct answer: Providing a logical alias that clients use to connect to a database or specific workload group
A service name is a logical identifier used in client connection strings; it can represent a single database, a PDB, or a subset of workloads for load balancing.
Question 5: What does the Oracle Net Listener do?
- Monitors database performance and generates AWR reports automatically
- Listens for incoming client connection requests on a port and hands them off to the database (Correct answer)
- Reads and validates the tnsnames.ora file for syntax errors
- Manages the pool of shared server processes for MTS connections
Correct answer: Listens for incoming client connection requests on a port and hands them off to the database
The Oracle Net Listener is a server-side process that accepts incoming network connection requests on a defined port and routes them to the appropriate database instance.
Question 6: In Oracle architecture, what is the difference between a segment and an extent?
- A segment is a single data block; an extent is a collection of segments
- A segment is a logical object (like a table) that consists of one or more extents; an extent is a contiguous set of data blocks (Correct answer)
- A segment is stored in memory; an extent is stored on disk
- A segment belongs to one tablespace; an extent can span multiple tablespaces
Correct answer: A segment is a logical object (like a table) that consists of one or more extents; an extent is a contiguous set of data blocks
A segment represents a database object (table, index, etc.) allocated within a tablespace; it grows by acquiring extents, which are contiguous groups of Oracle data blocks.
Question 7: Which Oracle tool would a DBA use to interactively diagnose performance issues by analyzing wait events, top SQL, and session activity in real time?
- RMAN
- Oracle SQL Developer's DBA panel
- Enterprise Manager Performance Hub (Correct answer)
- Data Pump
Correct answer: Enterprise Manager Performance Hub
The Enterprise Manager Performance Hub (available in EM Express and Cloud Control) provides real-time and historical performance analysis including ASH, ADDM, and top SQL.
1Z0-006 Oracle Architecture & Tools 5
What is the difference between a dedicated server and a shared server connection in Oracle?