nerdexam
Oracle

1Z0-082 · Question #108

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…

The correct answer is E. It must be the name of the server running the database to whose instance HR wishes to connect. See the full explanation below for the reasoning.

Configure the Oracle Network Environment

Question

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?

Options

  • AIt must be the value of the SERVICE_NAMES parameter on the client side
  • BIt must resolve to a valid connect descriptor in the server's tnsnames.ora file
  • CIt must resolve to a valid connect descriptor in the client's tnsnames.ora file
  • DIt must be the name of the database to whose instance HR wishes to connect
  • EIt must be the name of the server running the database to whose instance HR wishes to connect

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    6% (1)
  • C
    17% (3)
  • E
    72% (13)

Topics

#tnsnames.ora#name resolution#connect descriptor#listener

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice