Q106 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1

Q106 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• (A). Dynamic service registration cannot be used for this database instance
• (B). The LREG process registers services dynamically with the LISTENER_1 listener
• (C). LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• (D). There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• (E). The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration