Oracle Net Components and Protocols - Quiz Explanation
The correct answers are indicated below, along with text that explains the correct answers.
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.
The correct answer is C.
It is not true that the tnsnames.ora file contains everything that is needed to connect to the remote database, because the file does not contain the USER ID or password. These must be supplied either manually or through a database link. A is incorrect because it is true that the tnsnames.ora file provides the network-specific details about the remote database. B is incorrect because the tnsnames.ora file should use the host name, and not the actual remote server IP address. D is incorrect because 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
The correct answer is C.
The TNS listener establishes the connection to the remote database and creates the initial hookup. A is incorrect because the tnsnames.ora file provides connection details, but does not establish connections. B is incorrect because a database link only provides password and TNS names; it does not establish connections. D is incorrect because a protocol.ora file helps provide connection information, but does not establish a connection.
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
The correct answer is B.
The host name of the remote server is not contained in a database link; it is in the tnsnames.ora file. A is incorrect because the remote USER ID is contained in the database link. C is incorrect because the TNS service name is also contained in the database link. D is incorrect because the remote password is contained in the database link, as well.
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.
The correct answer is A.
It is not true that the Net client establishes the server process for the request. Instead, the remote listener establishes the request. B is incorrect because the service name is used to perform the look-up in the tnsnames.ora file. C is incorrect because database links and Net are both required for remote SQL connections. D is incorrect because it is true that 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
The correct answer is A.
Starting the TNS listener process is not a part of a Net client installation because the listener process exists only on the server, not on the client. B is incorrect because installing the Net client software is part of a Net client installation. C is incorrect because configuring the tnsnames.ora file is also part of a Net client installation.
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.
The correct answer is A.
It is not true that resource consumption in Net is greatest for the requesting client processor. In fact, almost 100% of the processing work is done on the remote server, not on the requesting client. B is incorrect because it is true that the protocol.ora file enables inter-protocol communications. C is incorrect because the listener process does exist only on Oracle servers. D is incorrect because it is true that, for a distributed query, database links can exist only on the client database.
