Oracle Database Administration I — Question 107

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information? (Choose three.)

Answer options

• A. Local Naming requires setting the TNS_ADMIN environment variable on the client side.
• B. A client can connect to an Oracle database instance even if no client side network admin has been configured.
• C. Directory Naming can be used if Connect-Time Failover is required.
• D. Easy Connect supports TCP/IP and SSL.
• E. Local naming can be used if Connect-Time Failover is required.
• F. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

Correct answer: B, C, E

Explanation

The correct answers are B, C, and E. B is correct because a client can connect without needing any specific client-side network configuration. C is accurate as Directory Naming can indeed be used for Connect-Time Failover. E is also right since Local Naming can support Connect-Time Failover. A and F are incorrect because both Local and Directory Naming do not require TNS_ADMIN to be set for their base functionalities.