Network Topology   «Prev  Next»

Oracle Net Components - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. Which of the following statements about the tnsnames.ora file is not true?
Please select the best answer.
  A. The tnsnames.ora file provides the network-specific details about the remote database.
  B. The tnsnames.ora file should use the host name, and not the actual remote server IP address.
  C. The tnsnames.ora file contains everything that is needed to connect to the remote database.
  D. The tnsnames.ora file should include the port number of the remote server.

2. Which of the following components establishes the connection to the remote database?
Please select the best answer.
  A. The tnsnames.ora file
  B. The database link
  C. The TNS listener
  D. The protocol.ora file

3. Which of the following is not contained in a database link?
Please select the best answer.
  A. The remote USER ID
  B. The host name of the remote server
  C. The TNS service name
  D. The remote password

4. Which of the following statements is not true about a Net connection?
Please select the best answer.
  A. The Net client establishes the server process for the request.
  B. The service name is used to perform the look-up in the tnsnames.ora file.
  C. Database links and Net are both required for remote SQL connections.
  D. The protocol.ora file contains cross-protocol information.

5. Which of the following procedures is not a part of a Net client installation?
Please select the best answer.
  A. Starting the TNS listener process
  B. Installing the Net client software
  C. Configuring the tnsnames.ora file
  D. None of the above

6. Which of the following characteristics of Net is false?
Please select the best answer.
  A. Resource consumption in Net is greatest for the requesting client processor.
  B. The protocol.ora file enables inter-protocol communications.
  C. The listener process exists only on Oracle servers.
  D. For a distributed query, database links can exist only on the client database.

Correct answers:

Your Score: 0