STUDY THIS TNSNAMES.ORA FILE

6. Study this tnsnames.ora file:

test = (description = (address_list = (address = (protocol = tcp)(host = serv2)(port = 1521)) ) (connect_data = (service_name = prod) )prod = (address = (protocol = tcp)(host = serv1)(port = 1521))dev = (service_name = dev)

Which of the following statements is correct about the connect strings test,

prod, and dev? (Choose all correct answers.)

A. All three are valid.

B. All three can succeed only if the instances are set up for dynamic instance

registration.

C. The test connection will fail, because the connect string doesn’t match the

service name.

D. There will be a port conflict on serv2, because prod and dev try to use the

same port.