Network Config   «Prev  Next»

Multi-Threaded Server - Quiz

Select the best answer or answers for each question.
1. Which of the following are valid actions for a listener to take when responding to an incoming connection request?
Please select all the correct answers.
  A. Spawn a dedicated server process and pass the client connection to it
  B. Redirect the client to a listener on another node, when remote listeners are configured (for example, in Oracle RAC)
  C. Hand the connection to a dispatcher, or redirect the client to one, when Shared Server is configured
  D. Execute the client's SQL statements and return the results

2. Which of the following are true regarding dedicated server processes?
Please select all the correct answers.
  A. A dedicated server process is always prespawned and waiting for the next incoming connection.
  B. A separate dedicated server process is started for each incoming client connection and services only that client's user process.
  C. In the default process mode, the UNIX ps command makes it easy to see how many dedicated connections exist, because each one has its own operating system process.

3. Which of the following views should a DBA query to monitor request queue activity, such as wait times, for Shared Server (formerly called MTS)?
Please select the best answer.
  A. The V$DISPATCHER view
  B. The V$SYSSTAT view
  C. The V$QUEUE view

4. Shared Server is enabled on a database. Which entry in the CONNECT_DATA section of a connect descriptor makes a session use a dedicated server process?
Please select the best answer.
  A. (SERVER=SHARED)
  B. (SERVER=POOLED)
  C. (SERVICE_NAME=DEDICATED)
  D. (SERVER=DEDICATED)

5. Even when Shared Server is configured, Oracle recommends that users and administrators explicitly connect through a dedicated server process in which of the following situations?
Please select all the correct answers.
  A. Submitting a batch job that allows little or no idle time for the server process
  B. Serving thousands of interactive sessions that spend most of their time idle between requests
  C. Running short, infrequent queries from a web application with long think times between requests
  D. Using Recovery Manager (RMAN) to back up, restore, or recover the database