The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.
You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.
BOSTON is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command:
CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING ‘denver’;
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database? (Choose the best answer)
A.
Execute this command as HR user in the BOSTON database and SYS user in the DENVER database.
B.
Execute this command as SYS user in both the databases.
C.
Execute this command as HR user in the DENVER database.
D.
Execute this command as HR user in the BOSTON database.
Explanation:
D
Here is something wrong.. How can be “…USING ‘denver’;” when denver is not defined in tnsnames?
D
How can be “…USING ‘denver’;” when denver is not defined in tnsnames?
i am agreee with you.
If the question is like:
The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. denver is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command:
CREATE DATABASE LINK DENVER CONNECT to hr IDENTIFIED BY hr USING ‘denver’;
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?
Then the answer is definitely D