Multiple choice technology databases

I must access a remote database using the SQLPLUS client executable

  1. I can connect only if there is a TNS entry in the server where the client executable resides

  2. I can connect only if there is a TNS entry in the server where the database resides

  3. No need for a TNS entry at all

  4. The Listener.ora will take care of the connection
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To use SQLPLUS to connect to a remote Oracle database, you need a TNS (Transparent Network Substrate) entry on the CLIENT side (where SQLPLUS executable resides), not the server side. The TNS entry in tnsnames.ora on the client machine tells SQLPLUS how to reach the remote database - the host, port, service name, and protocol. Without this client-side TNS entry, SQLPLUS doesn't know where to connect. The server's TNS configuration is irrelevant for the client connection attempt.

Keep practicing — related questions