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
If the database is configured for a shared server and a particular client requires a dedicated server, then you can configure the client to use a dedicated server in one of the following ways:
You can configure a network service name with a connect descriptor that contains (SERVER=dedicated) in the CONNECT_DATA section. For example:
sales=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.example.com)
(SERVER=dedicated)))
You can configure the client profile file, sqlnet.ora, with USE_DEDICATED_SERVER=on. This adds (SERVER=dedicated) to the CONNECT_DATA section of the connect descriptor the client uses.
https://docs.oracle.com/database/121/NETAG/dispatcher.htm#NETAG327
So, it is D for a single answer.
Just D
one-to-one ratio ==> definitly D