Oracle Database Administration I — Question 104

Which three statements are true about connection strings and service names used to connect to an Oracle database instance? (Choose three.)

Answer options

• A. A connection string must include the SID of a database instance.
• B. A connection string including a service name must be defined in the tnsnames.ora file.
• C. A single database instance can support connections for multiple service names.
• D. A single connection string can refer to multiple database instances.
• E. A service name is created by a listener.
• F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

Correct answer: C, D, F

Explanation

Option C is correct because a single database instance can indeed support multiple service names, allowing for better resource management. Option D is also correct since a connection string can be configured to connect to different instances based on the provided parameters. Option F is valid as well, as multiple connection strings in the same tnsnames.ora file can utilize the same service name, host, and port without conflict. Options A, B, and E are incorrect as they misrepresent the requirements and functions of connection strings and listeners in Oracle databases.