Examine the command:
SQL> CONNECT hr/hr@orcl
Which two configurations allow this command to execute successfully? (Choose two)
A.
In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
B.
The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
C.
The orcl TNS alias should be defined such that it is resolvable by a client running on the database host
D.
The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
E.
The TNS_ADMIN environment variable should be set to orcl on the client.
Explanation:
BC
BC
AC
BC