nerdexam
Oracle

1Z0-052 · Question #174

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

The correct answer is B. Local naming method. The local naming method resolves Oracle Net connection requests using connect descriptors stored in the client-side tnsnames.ora configuration file.

Configuring the Oracle Network Environment

Question

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

Options

  • AHost naming method
  • BLocal naming method
  • CExternal naming method
  • DDirectory naming method

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    87% (20)
  • D
    9% (2)

Why each option

The local naming method resolves Oracle Net connection requests using connect descriptors stored in the client-side tnsnames.ora configuration file.

AHost naming method

Host naming method resolves connections using the TCP/IP host name and a default port (1521) without needing a tnsnames.ora file.

BLocal naming methodCorrect

The local naming method reads the tnsnames.ora file stored on the client machine to map service names to connect descriptors containing the host, port, and service name required to connect to a remote Oracle database instance. This is the most widely used naming method in Oracle environments. It requires the tnsnames.ora file to be maintained and distributed to each client machine that needs to connect.

CExternal naming method

External naming method delegates resolution to a third-party naming service such as NIS or NDS, not a local flat file.

DDirectory naming method

Directory naming method uses an LDAP-compliant directory server such as Oracle Internet Directory to store and resolve connect descriptors, not a tnsnames.ora file.

Concept tested: Oracle Net local naming method and tnsnames.ora usage

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/identifying-and-accessing-database.html

Topics

#tnsnames.ora#local naming method#naming methods#connect descriptor

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice