nerdexam
Oracle

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.

Configuring the Oracle Network Environment

Question

View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener? (Choose two.)

Exhibit

1Z0-052 question #188 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)
  • A
    5% (1)
  • B
    80% (16)
  • C
    15% (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.

AThe ORCL instance is registered dynamically with the listener.

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.

BThe ORCL instance is registered statically in the listener.ora file.Correct

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).

CThe number of current client connections handled by the service handler is two.

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.

DThe total number of client connections handled so far by the service handler is two.Correct

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

#listener registration#static registration#dynamic registration#listener.ora

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice