1Z0-082 - Oracle Database Administration I Configuring Oracle Net Services Questions and Answers

Question 1

A client is attempting to connect to an Oracle database using the following connect string: `sqlplus scott/tiger@//dbhost:1527/orclpdb`.
This connection attempt is failing.
The administrator has verified the database is running and the listener on `dbhost` is configured to listen on port 1527 for the service `orclpdb`.
Which Oracle Net naming method is being used, and what is the key benefit of this method?

Accepted Answer

Easy Connect (or Host Naming), which allows for simple TCP/IP connections without requiring a `tnsnames.ora` file.

Answer

Directory Naming, which centralizes administration of network service names in an LDAP-compliant directory server.

Answer

Local Naming, which uses a local `tnsnames.ora` file to map service names to connect descriptors.

Answer

External Naming, which relies on a third-party naming service like NIS.

Question 2

A database administrator needs to ensure that clients resolve connect identifiers by first checking a local `tnsnames.ora` file, and if not found, then attempting to resolve using the Easy Connect naming method. Which parameter in the `sqlnet.ora` file should be configured to define this specific resolution order?

Accepted Answer

NAMES.DIRECTORY_PATH

Answer

SQLNET.AUTHENTICATION_SERVICES

Answer

NAMES.DEFAULT_DOMAIN

Answer

TNS_ADMIN

Question 3

You are troubleshooting a connection issue where a client receives an `ORA-12154: TNS:could not resolve the connect identifier specified` error. The client is configured to use the Local Naming method. Which of the following is the MOST likely cause of this error?

Accepted Answer

The net service name used in the connect string does not have a corresponding entry in the `tnsnames.ora` file.

Answer

The listener on the database server is not running.

Answer

The database service has not registered with the listener.

Answer

The client has provided an incorrect username or password.

Question 4

Which two Oracle Net Services configuration files are primarily involved in a standard client-server connection using the Local Naming method?

Accepted Answer

`listener.ora` and `tnsnames.ora`

Answer

`sqlnet.ora` and `protocol.ora`

Answer

`cman.ora` and `sqlnet.ora`

Answer

`tnsnames.ora` and `ldap.ora`

Question 5

A DBA is using the Oracle Net Manager (netmgr) graphical tool. Which of the following tasks can be accomplished using this utility?

Accepted Answer

Configuring listeners, naming methods, and network profiles.

Answer

Creating and managing database users and roles.

Answer

Starting and stopping the database instance.

Answer

Monitoring real-time database performance and executing SQL queries.

Question 6

An organization wants to centralize the management of its database connection information to avoid distributing and updating `tnsnames.ora` files on hundreds of client machines. Which Oracle Net naming method is best suited for this requirement?

Accepted Answer

Directory Naming

Answer

Local Naming

Answer

Host Naming

Answer

External Naming