Oracle
1Z0-062 · Question #378
1Z0-062 Question #378: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #378. The question stem and answer options stay visible for context.
Configuring the Oracle Network Environment
Question
The HR schema exists in databases, BOSTON and DENVER, with the same password, HR. You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases. DENVER is defined as a service name in the tnsnames.ora of both databases. You plan to use this command: CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?
Options
- AChange the command to create a public database link in BOSTON.
- BChange the command to create a public database link in DENVER.
- CExecute the command as SYS in DENVER.
- DExecute the command as SYS in BOSTON.
- EExecute the command as HR in BOSTON and SYS in DENVER.
- FExecute the command as SYS in both databases.
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#public database link#CREATE DATABASE LINK#user access