Oracle
1Z0-062 · Question #346
1Z0-062 Question #346: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #346. The question stem and answer options stay visible for context.
Configuring the Oracle Network Environment
Question
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?
Options
- AExecute this command as HR user in the BOSTON database and SYS user in the DENVER
- BExecute this command as SYS user in both the databases.
- CExecute this command as HR user in the DENVER database.
- DExecute this command as HR user in the BOSTON database.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#database link#user access#private database link