The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.
User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.
Examine these commands:
Conn SALES/SALES123
CREATE DATABASE LINK orcl2 USING ‘orcl2’;
What is the outcome of executing these commands in the ORCL1 database?
A.
ORCL2 is created as a public database link to connect a single session to the SALES schema in the
ORCL2 database.
B.
ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the
ORCL2 database.
C.
ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.
D.
ORCL2 database link creation fails.