nerdexam
Oracle

1Z0-062 · Question #363

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

The correct answer is A. Dynamic Registration by the LREG process E. Static registration in the listener.ora file using the SERVICE_NAME parameter. In Oracle Database 12c, a database service is recognized by a listener primarily through dynamic registration by the LREG process or through static configuration in the listener.ora file using the SERVICE_NAME parameter.

Configuring the Oracle Network Environment

Question

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

Options

  • ADynamic Registration by the LREG process
  • BDynamic Registration by the SMON process
  • CStatic registration in the listener.ora file using the GLOBAL_DBNAME parameter
  • DDynamic Registration by the PMON process
  • EStatic registration in the listener.ora file using the SERVICE_NAME parameter

How the community answered

(58 responses)
  • A
    90% (52)
  • B
    5% (3)
  • C
    3% (2)
  • D
    2% (1)

Why each option

In Oracle Database 12c, a database service is recognized by a listener primarily through dynamic registration by the LREG process or through static configuration in the listener.ora file using the SERVICE_NAME parameter.

ADynamic Registration by the LREG processCorrect

In Oracle 12c and later, the LREG (Listener Registration) background process is specifically tasked with dynamically registering information about database services and their dispatchers with the listener.

BDynamic Registration by the SMON process

The SMON (System Monitor) process manages instance recovery and temporary segments, but it is not involved in registering database services with the listener.

CStatic registration in the listener.ora file using the GLOBAL_DBNAME parameter

Static registration in the listener.ora file uses the SERVICE_NAME or SID_NAME parameters, not the GLOBAL_DBNAME parameter, for service recognition.

DDynamic Registration by the PMON process

While PMON previously handled listener registration, in Oracle 12c and later, the LREG process has taken over the responsibility for dynamic service registration with the listener.

EStatic registration in the listener.ora file using the SERVICE_NAME parameterCorrect

Static registration involves manually configuring service information within the listener.ora file, typically using the SERVICE_NAME parameter in the SID_LIST section, which allows the listener to recognize services that may not dynamically register.

Concept tested: Oracle Listener service registration 12c

Source: https://docs.oracle.com/database/121/NETRF/listener.htm#NETRF194

Topics

#Listener#service registration#LREG#PMON

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice