QUESTION 29 As an Administrator, when you create a Database Link, which of the file given...
Micron technical mcq question, verified with a worked answer. Free to practise - no sign-up.
QUESTION 29
As an Administrator, when you create a Database Link, which of the file given in options is used by the Database Link to resolve the remote database connection?
Show answer & explanation
The tnsnames.ora file is the client-side configuration file that contains the Transparent Network Substrate (TNS) service names and their corresponding database connection descriptors. When a Database Link attempts to connect to a remote database, it uses tnsnames.ora to resolve the remote database's service name into the actual connection details (host, port, SID/service name). The sqlnet.ora file controls network behavior, listener.ora configures the listener process on the server side, and grapwd.ora is for password management—none of these are used for resolving remote database connections in Database Links.
Step-by-step Derivation:
Database Links require a mechanism to translate a remote database identifier into actual connection parameters. Oracle's TNS (Transparent Network Substrate) layer uses tnsnames.ora as the client-side name resolution file. When you create a Database Link with a remote database identifier, the local database queries tnsnames.ora to find the connection descriptor for that remote database, which includes host, port, and service name information necessary to establish the connection.