1Z0-052 · Question #188
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener? (Choose two.)
The correct answer is B. The ORCL instance is registered statically in the listener.ora file. D. The total number of client connections handled so far by the service handler is two. The LISTENER2 status output shows the ORCL instance is statically configured in listener.ora and that the service handler has processed a cumulative total of two client connections.
Question
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener? (Choose two.)
Exhibit
Options
- AThe ORCL instance is registered dynamically with the listener.
- BThe ORCL instance is registered statically in the listener.ora file.
- CThe number of current client connections handled by the service handler is two.
- DThe total number of client connections handled so far by the service handler is two.
How the community answered
(20 responses)- A5% (1)
- B80% (16)
- C15% (3)
Why each option
The LISTENER2 status output shows the ORCL instance is statically configured in listener.ora and that the service handler has processed a cumulative total of two client connections.
Dynamic registration is performed automatically by the PMON background process at instance startup; the exhibit reflects a statically defined entry in listener.ora, not a dynamically registered service.
Static registration means the service and instance details are manually defined in listener.ora under a SID_LIST_LISTENER entry; the exhibit output for LISTENER2 shows service handler attributes consistent with static registration (no PMON-registered dynamic service properties such as load metrics or instance mode).
The connection count of two represents the total established (cumulative) connections, not the number of connections currently active at the time the listener status was queried.
The 'Established' or 'Total' connection count shown in lsnrctl status output reflects the cumulative number of connections the service handler has processed since the listener started, not the count of currently active sessions.
Concept tested: Oracle listener static vs dynamic service registration and connection counts
Source: https://docs.oracle.com/cd/E11882_01/network.112/e10836/listener.htm
Topics
Community Discussion
No community discussion yet for this question.
