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 mts_dispatcher init.ora parameter are true?
Please select all the correct answers.
  A. You can define multiple protocols for each dispatcher.
  B. You can define many dispatcher processes with this parameter.
  C. You can define the target protocol for the dispatcher with this parameter.

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

4. Which of the following operations are permitted through an MTS 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