Oracle Database 12c: Installation and Administration — Question 45

Which statement is true about Oracle Net Listener?

Answer options

• A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B. A single listener can service only one database instance and multiple remote client connections.
• C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
• D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Correct answer: C

Explanation

The correct answer is C because the process monitor (PMON) is responsible for registering the database service with the listener. Option A is incorrect as the listener can service multiple instances, option B is wrong because a listener can handle multiple instances, option D is inaccurate as the listener.ora file can be configured differently, and option E is misleading since the listener.ora file location may vary.