Network Config   «Prev  Next»

Oracle Listener Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following are benefits of a dedicated server process compared to a Shared Server (formerly Multi-Threaded Server, or MTS) connection?
Please select all the correct answers.
  A. Dedicated server processes are easier to identify than shared server connections.
  B. Dedicated server processes use fewer resources than shared server connections.
  C. Dedicated server processes are simpler to monitor than shared server connections.
  D. Dedicated server processes can be seen as distinct operating system processes.

2. Which of the following are benefits of using Shared Server (formerly Multi-Threaded Server, or MTS)?
Please select all the correct answers.
  A. Reduced memory usage
  B. Fewer processes needed to support a large number of users
  C. Automatic load balancing across dispatchers
  D. Simpler DBA configuration and maintenance than a dedicated server

3. Where is a session's User Global Area (UGA) stored?
Please select the best answer.
  A. In the PGA, for both dedicated and shared server connections
  B. In the PGA for a dedicated server connection, and in the SGA for a shared server connection
  C. In the SGA, for both dedicated and shared server connections

4. Which Oracle background process registers the location and current load of shared server dispatchers with the listener?
Please select the best answer.
  A. PMON
  B. LREG
  C. SMON
  D. DBWn

5. Which initialization parameter, when set to a nonzero value, enables Shared Server?
Please select the best answer.
  A. MAX_SHARED_SERVERS
  B. DISPATCHERS
  C. SHARED_SERVERS
  D. CIRCUITS