nerdexam
Oracle

1Z0-062 · Question #147

The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes…

The correct answer is D. connecting by using the local naming method with the server = dedicated parameter set in the. To request a dedicated server connection when Oracle Database is configured for shared server, users must connect using a net service name that is configured to use a dedicated server. Specifically, the net service name value should include the SERVER=DEDICATED clause in the…

Configuring the Oracle Network Environment

Question

The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes. Which connection method guarantees that this requirement is met?

Options

  • Aconnecting by using an external naming method
  • Bconnecting by using the easy connect method
  • Ccreating a service in the database by using the dbms_service.create_service procedure and using
  • Dconnecting by using the local naming method with the server = dedicated parameter set in the
  • Econnecting by using a directory naming method

How the community answered

(45 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    13% (6)
  • D
    78% (35)
  • E
    4% (2)

Explanation

To request a dedicated server connection when Oracle Database is configured for shared server, users must connect using a net service name that is configured to use a dedicated server. Specifically, the net service name value should include the SERVER=DEDICATED clause in the connect descriptor.

Topics

#shared server#dedicated server#connection methods#listener configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice