Network Config   «Prev  Next»

Oracle Shared Server Concepts- Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following will occur if too many dispatchers are defined?
Please select the best answer.
  A. Incoming connections will have to wait for the listener.
  B. There will be unnecessary extra server processes.
  C. There will be excessive connect times for dedicated connections.

2. Which of the following statements about the DISPATCHERS init.ora parameter are true?
Please select all the correct answers.
  A. You can define multiple protocols for each dispatcher configuration entry.
  B. You can define how many dispatcher processes to start with this parameter.
  C. You can define the target protocol for a set of dispatchers with this parameter.

3. Which of the following statements about Oracle Shared Server is true?
Please select the best answer.
  A. Shared Server places an additional burden on the Oracle shared pool, and you cannot use a dedicated connection if Shared Server is configured.
  B. You cannot use a dedicated connection if Shared Server is configured, and Shared Server requires that at least one dispatcher exist.
  C. Shared Server places an additional burden on the Oracle shared pool and requires that at least one dispatcher exist.

4. Which of the following operations are permitted through a Shared Server connection?
Please select all the correct answers.
  A. Creating an Oracle table
  B. Stopping an Oracle database
  C. Querying the V$DISPATCHER view
  D. Changing the init.ora file

5. Which background process automatically starts additional shared server processes as demand increases, up to the MAX_SHARED_SERVERS limit?
Please select the best answer.
  A. LREG
  B. SMON
  C. DBWn
  D. PMON