Network Topology   «Prev  Next»

Oracle Net Components - Quiz

Each question is worth one point. Select the best answer for each question.
1. Which statement about local naming with tnsnames.ora is incorrect?
Please select the best answer.
  A. The file maps a net service name to a connect descriptor.
  B. The HOST parameter can identify a listener host by hostname or IP address.
  C. A tnsnames.ora entry by itself guarantees successful authentication and access to a remote database.
  D. A TCP connect descriptor includes the listener address and database service information.

2. Which Oracle Net component receives an initial client connection request and directs it to the appropriate database server handler?
Please select the best answer.
  A. The tnsnames.ora file
  B. The database link definition
  C. The Oracle Net listener
  D. The sqlnet.ora profile

3. What is the purpose of an Oracle database link?
Please select the best answer.
  A. To replace the listener for every remote client connection.
  B. To let SQL executed in one database reference objects in another database.
  C. To require every client to maintain a local tnsnames.ora file.
  D. To store the same fixed username and password for every kind of remote connection.

4. Which statement correctly distinguishes a direct remote client connection from a database-link connection?
Please select the best answer.
  A. Every SQL client needs a database link before it can connect remotely.
  B. A database link replaces Oracle Net naming and transport.
  C. The database service name must always be identical to the local naming alias.
  D. A client can connect directly through Oracle Net without a database link; a database link supports access from one database to another.

5. For a client that only initiates direct connections using Easy Connect, which task is normally unnecessary on the client computer?
Please select the best answer.
  A. Starting a local Oracle Net listener.
  B. Installing or providing a compatible client driver or client software.
  C. Providing the destination host and the required service connection details.
  D. Ensuring network connectivity to the destination listener.

6. Which description of Oracle Net configuration files is correct?
Please select the best answer.
  A. protocol.ora is the primary Oracle 26ai file for configuring all naming methods.
  B. listener.ora stores every application user password.
  C. sqlnet.ora configures Oracle Net profile settings; tnsnames.ora defines local naming aliases; listener.ora configures listeners.
  D. tnsnames.ora determines what percentage of query processing runs on the client.