RelationalDBDesign RelationalDBDesign


Serverside Configuration   «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 valid types of listener?
Please select all the correct answers.
  A. A listener that is polling three addresses for three different protocols
  B. A listener that passes requests to a multi-threaded dispatcher
  C. A listener that makes a direct connection to the Oracle database
  D. A listener that allows SNMP connections from a mainframe

2. Which of the following commands is used to start a SQL*Net version 1 listener?
Please select the best answer.
  A. tcpctl start
  B. tcpctl start listener
  C. lsnrctl start
  D. Lsnrctl start listener

3. What is the main disadvantage to using Oracle Net Assistant?
Please select the best answer.
  A. It is not practical for large Oracle networks because manually created parameter files cannot always be processed.
  B. It is easier to edit the parameter files manually.
  C. The Oracle Net Assistant does not have the flexibility to allow manual editing.
  D. The Oracle Net Assistant wizards are not very intuitive.

4. If you have very high connection volumes, what is the best approach to configuring the listener?
Please select the best answer.
  A. Create multiple listeners on the server.
  B. Create a multi-protocol listener.
  C. Create the listener with additional service handlers.
  D. Create a multi-threaded server for each database.

5. Which of the following commands is used to see the available listener control commands?
Please select the best answer.
  A. lsnrctl help
  B. lsnrctl syntax
  C. tcpctl help
  D. lsnrctl ?

6. Which of the following statements about the Oracle Net listener is not true?
Please select the best answer.
  A. The listener contains an entry for each database on the host.
  B. The listener process will start automatically when the database is started.
  C. The listener runs as an independent process on the server.
  D. The listener can be "bounced" without affecting existing connections.

7. Which of the following statements about Oracle Net multi-protocol support is not true?
Please select the best answer.
  A. Multi-protocol support requires defining a multi-threaded server for each database.
  B. Oracle Net protocols are defined in the listener.ora file.
  C. The Oracle Net Connection Manager can be used in lieu of multi-protocols in the listener.ora file.
  D. The Oracle Net listener can support protocols from PCs, mainframes, and virtually every type of remote protocol.