Oracle Database 12c: Installation and Administration — Question 63

Examine this command executed on a client that is remote from the database server.

SQL> CONNECT hr/hr@orcl -
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

Answer options

• A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files
• B. An orcl TNS entry must be defined in the client-side tnsnames.ora file
• C. A service name must be defined to the listener that matches the service name in the orcl TNS entry
• D. An orcl TNS entry must be defined in the server-side tnsnames.ora file
• E. The service name orcl must be defined to the listener

Correct answer: D, E

Explanation

To connect using SQLPLUS, the server must have an orcl TNS entry defined in its tnsnames.ora file (option D) and the listener must recognize the service name orcl (option E). Options A, B, and C are incorrect because they do not address the necessity of having the required configurations on the server side.