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?
A.
connecting by using an external naming method
B.
connecting by using the easy connect method
C.
creating a service in the database by using the dbms_service.create_service procedure and using this
service for creating a local naming service
D.
connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora
file for the net service
E.
connecting by using a directory naming method
It should be D. By default, if Oracle Shared Server is configured, a client is connected to a dispatcher unless the client explicitly requests a dedicated connection. Clients can request dedicated connections if the names resolution method is local naming, which is done so by adding the parameter, SERVER=DEDICATED, to the service-name entry in the tnsnames.ora file.