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
Explanation:
CD
They ask for one method. So I think just D.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11167
“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.”
So I think D is ans
D
D
Same as Liz said, also reference to 12c doc
http://docs.oracle.com/database/121/ADMIN/manproc.htm#ADMIN11167
D is the only answer which is correct. Create service procedure dont have any attribute for dedicated and share.
Also this type of connection is maintained at connection level.
D
D
I think B and D. Because with easy connection you can specify server type: dedicaded or shared.
D
D, E:
D: 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.
https://docs.oracle.com/database/121/NETAG/dispatcher.htm#NETAG327
E: If shared server is configured in the initialization parameter file, you can select Dedicated Server to force the listener to spawn a dedicated server, bypassing shared server configuration. If shared server is configured in the initialization parameter file and you want to guarantee the connection always uses shared server, select Shared Server.
https://docs.oracle.com/cd/B19306_01/network.102/b14212/naming.htm#i513222
BD
http://www.oracle.com/technetwork/database/enterprise-edition/oraclenetservices-neteasyconnect-133058.pdf
username@[//]host[:port][/service_name][:server][/instance_name]
is optional, should be one of {DEDICATED, SHARED, POOLED}.
The default is to leave it unspecified, and let the listener decide.
e.g. sqlplus hr/hr@//localhost:1521/PDB1:DEDICATED/ORCL