nerdexam
Oracle

1Z0-062 · Question #355

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…

The correct answer is 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. For a remote client to connect using CONNECT hr/hr@orcl, the server's listener must know about the service name orcl, and the server-side configuration may also require an orcl TNS entry for internal resolution.

Configuring the Oracle Network Environment

Question

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.)

Options

  • AAn orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files
  • BAn orcl TNS entry must be defined in the client-side tnsnames.ora file
  • CA service name must be defined to the listener that matches the service name in the orcl TNS
  • DAn orcl TNS entry must be defined in the server-side tnsnames.ora file
  • EThe service name orcl must be defined to the listener

How the community answered

(66 responses)
  • A
    8% (5)
  • B
    3% (2)
  • C
    3% (2)
  • D
    86% (57)

Why each option

For a remote client to connect using `CONNECT hr/hr@orcl`, the server's listener must know about the service name `orcl`, and the server-side configuration may also require an `orcl` TNS entry for internal resolution.

AAn orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

While a client-side TNS entry is typically required, a server-side TNS entry is not universally required for a remote client's incoming connection, making this option partially incorrect.

BAn orcl TNS entry must be defined in the client-side tnsnames.ora file

While a client-side `tnsnames.ora` entry is a common way to resolve the alias 'orcl', other client-side naming methods like Easy Connect naming or Directory Naming (LDAP) can also be used, making it not an absolute requirement in all scenarios.

CA service name must be defined to the listener that matches the service name in the orcl TNS

This statement is largely redundant with option E, which more directly and broadly addresses the listener's fundamental requirement to know the service name being requested by the client.

DAn orcl TNS entry must be defined in the server-side tnsnames.ora fileCorrect

An `orcl` TNS entry may be required in the server-side `tnsnames.ora` file if the database instance uses this entry to define its own service name for registration with the listener or for specific internal network configurations, such as when `LOCAL_LISTENER` or `REMOTE_LISTENER` parameters refer to a TNS alias.

EThe service name orcl must be defined to the listenerCorrect

The service name `orcl` must be defined to the listener, either through dynamic registration by the database instance's PMON process or static configuration in the `listener.ora` file, so the listener can correctly route the client's connection request to the appropriate database instance.

Concept tested: Oracle client-server database connection requirements

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-oracle-net-listener.html#GUID-00A91D0E-C24D-4F60-91E3-5E1B842F79A1

Topics

#Oracle Net Services#tnsnames.ora#listener#service name

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice