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?
A.
It must be the name of the database to whose instance HR wishes to connect.
B.
It must resolve to a valid connect descriptor in the client's tnsnames.ora file.
C.
It must be the name of the server running the database to whose instance HR wishes to connect.
D.
It must resolve to a valid connect descriptor in the server's tnsnames.ora file.
E.
It must be the value of the SERVICE_NAMES parameter on the client side.
A.False. ORCL is a TNS alias, not necessarily the DB name.
B.True. Must map to a connect descriptor (e.g., HOST=... PORT=1531) in tnsnames.ora.
C.False. It’s not the server name but a network alias.
D.False. Client-side tnsnames.ora is used, not server-side.
E.False. SERVICE_NAMES is server-side, not client-side.
[References:Oracle Database Net Services Administrator’s Guide 23ai, "TNSNAMES.ORA.", , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit