nerdexam
Oracle

1Z0-052 · Question #42

Which two statements are true regarding listeners? (Choose two.)

The correct answer is B. Multiple listener processes can run simultaneously on a host. C. Multiple database instances can be registered with a single listener. Oracle Net listeners are flexible in protocol support and registration, allowing multiple listeners per host and multiple database instances per listener.

Configuring the Oracle Network Environment

Question

Which two statements are true regarding listeners? (Choose two.)

Options

  • AListeners use only the TCP/IP protocol.
  • BMultiple listener processes can run simultaneously on a host.
  • CMultiple database instances can be registered with a single listener.
  • DThe listener-related errors can be traced only at the administrative level.
  • EOnly one database instance can be registered with a single listener at any time.

How the community answered

(52 responses)
  • A
    6% (3)
  • B
    90% (47)
  • D
    2% (1)
  • E
    2% (1)

Why each option

Oracle Net listeners are flexible in protocol support and registration, allowing multiple listeners per host and multiple database instances per listener.

AListeners use only the TCP/IP protocol.

Oracle listeners support multiple protocols including TCP/IP, IPC (Inter-Process Communication), and Named Pipes on Windows, not just TCP/IP.

BMultiple listener processes can run simultaneously on a host.Correct

Multiple listener processes can run simultaneously on a single host by configuring each listener with a unique name and port in listener.ora, enabling workload separation or support for multiple protocol endpoints.

CMultiple database instances can be registered with a single listener.Correct

Multiple database instances can register with a single listener through dynamic service registration (LREG process) or static configuration in listener.ora, allowing one listener to route connections to many databases.

DThe listener-related errors can be traced only at the administrative level.

Listener tracing can be configured at multiple levels - off, user, admin, and support - not exclusively at the administrative level.

EOnly one database instance can be registered with a single listener at any time.

A single listener can simultaneously serve many database instances via dynamic service registration, making this statement false.

Concept tested: Oracle Net listener configuration and capabilities

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/enabling-advanced-features-oracle-net-services.html

Topics

#listeners#database registration#network configuration#multiple instances

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice