You add the following code in the tnsnames.ora file on a client PC:
sales=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) )
(CONNECT_DATA=
(SERVICE_NAME=sales.acme)))
Which statement is true about the code with respect to creating a new connect identifier?
A.
It is created for the SALES database in the network domain ACME on the SALESDATA server.
B.
It is created for the SALESDATA database on the SALES server in the network domain called ACME.
C.
It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.
D.
It generates an error because the server configuration mode (dedicated or shared) is not specified.
Explanation:
* Example, Basic Format of tnsnames.ora File
net_service_name=
(DESCRIPTION=
(ADDRESS=(protocol_address_information))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))
* This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors
for the local naming method, or net service names mapped to listener protocol addresses.
A net service name is an alias mapped to a database network address contained in a connect descriptor. A
connect descriptor contains the location of the listener through a protocol address and the service name of the
database to which to connect. Clients and database servers (that are clients of other database servers) use the
net service name when making a connection with an application.