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 listener?
Please select all the correct answers.
  A. Dedicated listener processes are easier to identify than MTS connections.
  B. Dedicated listener processes use fewer resources than MTS connections.
  C. Dedicated listener processes are simpler to monitor than MTS connections.
  D. Dedicated listener processes can be seen as UNIX processes.

2. Which of the following are benefits of using MTS?
Please select all the correct answers.
  A. Reduced memory usage
  B. Fewer processes per user
  C. Automatic load balancing
  D. Simple DBA maintenance

3. Under what circumstances would a dedicated listener process be preferable to an MTS connection?
Please select the best answer.
  A. I/O-intensive SQL queries
  B. Connections that require distributed queries
  C. Sorting intensive SQL queries