As a user of the ORCL database, you establish a database link to the remote HQ database
such that all users in the ORCL database may access tables only from the SCOTT schema
in the HQ database. SCOTT’s password is TIGER. The service mane “HQ” is used to
connect to the remote HQ database. Which command would you execute to create the
database link?
A.
CREATE DATABASE LINK HQ USING ‘HQ’;
B.
CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ’ S
C.
CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger
USING ‘HQ’;
D.
CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING ‘HQ’;
Explanation:
Is this one correct?
“Database links are either private or public. If they are private, then only the user who created the link has access; if they are public, then all database users have access.”
From doc https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm
I suppose option C looks better?
ALL USERS in the ORCL database may access tables only from the SCOTT schema
-> create PUBLIC
C
C