1Z0-062 · Question #141
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…
The correct answer is C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ'. 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. According to question it should be public which can be accessed by all users. Since all users are…
Question
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?
Options
- ACREATE DATABASE LINK HQ USING 'HQ';
- BCREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING HQ';
- CCREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
- DCREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
How the community answered
(27 responses)- A15% (4)
- B4% (1)
- C74% (20)
- D7% (2)
Explanation
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. According to question it should be public which can be accessed by all users. Since all users are connected as scott, so it should be a fixed user link.
Topics
Community Discussion
No community discussion yet for this question.