View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener? (Choose two.)
A.
The ORCL instance is registered dynamically with the listener.
B.
The ORCL instance is registered statically in the listener.ora file.
C.
The number of current client connections handled by the service handler is two.
D.
The total number of client connections handled so far by the service handler is two.
Explanation:
Database Service Registration
For a listener to forward client connections to an instance, the listener must know the name of the
instance and where the instance’s ORACLE_HOME is located. The listener can find this
information in two ways:
Dynamic service registration: Oracle8i and later instances automatically register with the default
listener on database startup. No additional listener configuration is required for the default listener.
Static service registration: Earlier releases of the Oracle database do not automatically register
with the listener and, therefore, require that the listener configuration file contain a list of all
database services that the listener will serve. You may still choose to use static service registration
with newer releases if:
– Your listener is not on the default port of 1521, and you do not want to configure your instance to
register with a nondefault port
– Your application requires static service registration