1Z0-006 Oracle Architecture & Tools 5

Question 1

What is the difference between a dedicated server and a shared server connection in Oracle?

Accepted Answer

In dedicated server, each session has its own server process; in shared server, multiple sessions share server processes

Answer

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?

Accepted Answer

tnsnames.ora

Answer

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?

Accepted Answer

LGWR

Answer

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?

Accepted Answer

Providing a logical alias that clients use to connect to a database or specific workload group

Answer

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?

Accepted Answer

Listens for incoming client connection requests on a port and hands them off to the database

Answer

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.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Oracle Architecture & Tools 5