Oracle Architecture & Tools 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 Architecture & Tools flashcards as text
What is the difference between a dedicated server and a shared server connection in Oracle?
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.
Which Oracle network component resolves a service name (like 'ORCL') to a database host, port, and service name?
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.
Which background process writes redo entries from the Redo Log Buffer to the online redo log files?
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.
What is an Oracle Service Name used for?
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.
What does the Oracle Net Listener do?
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.
In Oracle architecture, what is the difference between a segment and an extent?
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.
Which Oracle tool would a DBA use to interactively diagnose performance issues by analyzing wait events, top SQL, and session activity in real time?
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.