Oracle Database Administration I — Question 63

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl -
No name server is used.
Which statement is true about ORCL?

Answer options

• A. It must be the value of the SERVICE_NAMES parameter on the client side
• B. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• C. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• D. It must be the name of the database to whose instance HR wishes to connect
• E. It must be the name of the server running the database to whose instance HR wishes to connect

Correct answer: C

Explanation

The correct answer is C because ORCL must resolve to a valid connect descriptor in the client's tnsnames.ora file for the connection to succeed. Option A is incorrect since SERVICE_NAMES is a server-side parameter, and B is wrong because the server's tnsnames.ora file is not relevant in this context. D and E are also incorrect as they misinterpret the nature of ORCL being a connect descriptor rather than just a name or server reference.