1Z0-052 Question #59: Real Exam Question with Answer & Explanation

The correct answer is B: When DBAs need to connect remotely to start up the database instance. Static listener registration is configured manually in listener.ora and persists even when the database instance is down. This is required when a DBA must remotely connect to start an instance that has not yet registered itself dynamically via PMON.

Configuring the Oracle Network Environment

Question

In which situation would you use static database registration for a listener?

Options

AWhen multiple databases are to be registered with the listener
BWhen DBAs need to connect remotely to start up the database instance
CWhen users need to connect the database instance using the host naming method
DWhen the database instance that is to be registered with the listener is configured in shared server mode

Explanation

Static listener registration is configured manually in listener.ora and persists even when the database instance is down. This is required when a DBA must remotely connect to start an instance that has not yet registered itself dynamically via PMON.

Common mistakes.

A. Multiple databases can be registered with a single listener using dynamic registration via PMON without requiring static configuration.
C. Host naming resolution is a client-side naming method and does not impose a requirement for static listener registration.
D. Shared server mode configuration is handled through the DISPATCHERS parameter and dynamic registration; it does not specifically require static registration in listener.ora.

Concept tested. Oracle listener static vs dynamic registration use cases

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-and-administering-oracle-net-listener.html

Topics

#static registration#listener#dynamic registration#remote startup

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice