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:

LISTENER_1=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=host1.abc.com)

(PORT=1521)

)

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

source:cuug