exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 320 discussion

Actual exam question from Oracle's 1z0-062
Question #: 320
Topic #: 1
[All 1z0-062 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
melat
Highly Voted 4 years, 10 months ago
The answer is D.
upvoted 15 times
...
Ray520
Most Recent 3 years ago
Creating a link as HR user means link is owned by HR user and hence only HR user can access it. So answer is D
upvoted 1 times
...
NorthKorean
5 years, 2 months ago
The answer is A
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...