Oracle Database 12c: Installation and Administration — Question 158

Which two statements are true about Oracle network connections? (Choose two.)

Answer options

• A. A listener may listen on behalf of only one database instance at a time.
• B. A server process checks a user’s authentication credentials and creates a session if the credentials are valid.
• C. The listener continuously monitors a connection after the user process connects to a service handler.
• D. The listener always spawns a new server process to deal with each new connection.
• E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

Correct answer: B, E

Explanation

Option B is correct because the server process is responsible for validating user credentials and establishing a session upon successful authentication. Option E is also accurate as the listener is designed to accept connection requests on the specified port before forwarding them to the appropriate database service. The other options are incorrect because they either misrepresent the functionality of the listener or the server process.