Oracle Database 12c: Installation and Administration — Question 148

Examine the command:

SQL> CONNECT hr/hr@orcl -
Which two configurations allow this command to execute successfully? (Choose two.)

Answer options

• A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
• B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
• C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.
• D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
• E. The TNS_ADMIN environment variable should be set to orcl on the client.

Correct answer: B, C

Explanation

Option B is correct because the SERVICE_NAMES parameter must include 'orcl' for the connection to be recognized. Option C is also correct as the orcl TNS alias must be resolvable from the client on the database host. Options A, D, and E are incorrect as they do not specifically address the requirements for the command to execute successfully.