nerdexam
Oracle

1Z0-062 · Question #219

Which two statements are true about Oracle network connections?

The correct answer is B. A server process checks a user's authentication credentials and creates a session if the D. The listener always spawns a new server process to deal with each new connection. In Oracle networking, the server process handles credential authentication after the listener hands off the connection, and in dedicated server mode the listener spawns a new server process per connection.

Configuring the Oracle Network Environment

Question

Which two statements are true about Oracle network connections?

Options

  • AA listener may listen on behalf of only one database instance at a time.
  • BA server process checks a user's authentication credentials and creates a session if the
  • CThe listener continuously monitors a connection after the user process connects to a service
  • DThe listener always spawns a new server process to deal with each new connection.
  • EA connection request from a client is always first received by a listener running on the port that

How the community answered

(21 responses)
  • B
    90% (19)
  • C
    5% (1)
  • E
    5% (1)

Why each option

In Oracle networking, the server process handles credential authentication after the listener hands off the connection, and in dedicated server mode the listener spawns a new server process per connection.

AA listener may listen on behalf of only one database instance at a time.

A single Oracle listener can register and listen on behalf of multiple database instances simultaneously through static listener.ora configuration or dynamic service registration via LREG.

BA server process checks a user's authentication credentials and creates a session if theCorrect

After the Oracle listener accepts an incoming client connection and performs the initial redirect, the dedicated server process is responsible for verifying the user's authentication credentials and establishing the database session on behalf of that client.

CThe listener continuously monitors a connection after the user process connects to a service

The listener's responsibility ends once it hands off the client connection to the server process; it does not continuously monitor or maintain the connection after the initial handoff is complete.

DThe listener always spawns a new server process to deal with each new connection.Correct

In the default dedicated server mode, the Oracle listener spawns a new dedicated server process for each incoming client connection request, providing each session with its own dedicated server-side process.

EA connection request from a client is always first received by a listener running on the port that

The listener receives connection requests on its preconfigured port (default 1521), which is defined server-side; the client must connect to that port - the client does not unilaterally determine which port the listener monitors.

Concept tested: Oracle listener architecture and dedicated server process handling

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/understanding-oracle-net-architecture.html

Topics

#listener#server processes#network connection#user authentication

Community Discussion

No community discussion yet for this question.

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