Network Config   «Prev  Next»

Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following is true about configuring shared server processes?
Please select the best answer.
  A. Shared server processes will be allocated automatically when needed, and you should set SHARED_SERVERS to a high initial value.
  B. Shared server processes will be allocated automatically when needed and de-allocated when they are not needed.
  C. Shared server processes will be de-allocated when they are not needed, and you should set SHARED_SERVERS to a high initial value.

2. What would you do to compute the busy rate for Shared Server dispatchers?
Please select the best answer.
  A. Query the V$QUEUE view
  B. Query the V$DISPATCHER view
  C. Run the equation for busy rate with no source data

3. Which of the following views will give you the average wait time per response from Shared Server?
Please select the best answer.
  A. The V$QUEUE view
  B. The V$DISPATCHER view
  C. The V$SGA view

4. Which view identifies the current status of one specific client connection passing through Shared Server, including whether it is waiting on the common queue or already being serviced?
Please select the best answer.
  A. V$SESSION
  B. V$QUEUE
  C. V$CIRCUIT

5. An instance has SHARED_SERVERS set to 5 and DISPATCHERS left completely unset. What happens to dispatchers when the instance starts?
Please select the best answer.
  A. Shared Server fails to start without an explicit DISPATCHERS entry.
  B. Oracle creates five dispatchers, matching SHARED_SERVERS.
  C. No dispatchers are created; only shared servers start.
  D. Oracle creates one dispatcher for the TCP protocol automatically.