Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Oracle 1Z0-082 Exam - Topic 8 Question 125 Discussion

Actual exam question for Oracle's 1Z0-082 exam
Question #: 125
Topic #: 8
[All 1Z0-082 Questions]

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.

Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

Examine this command:

CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db';

How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

Show Suggested Answer Hide Answer
Suggested Answer: B

https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085

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.

https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205


by Yvonne at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Jeanice
3 days ago
A) as SCOTT in DALLAS_DB? Hmm, I don't know, seems a bit too straightforward. Where's the challenge? Where's the fun?
upvoted 0 times
...
Pura
8 days ago
C) as SCOTT in BOSTON_DB and SYS in DALLAS_DB. Ah, the classic "let's just throw every admin account at it and see what sticks" approach. I'm sure that'll work out great.
upvoted 0 times
...
Cory
30 days ago
E) as SCOTT in both the databases? Haha, good one! Next, you'll tell me to use the same password for all my online accounts. Security is for the weak, right?
upvoted 0 times
...
Mira
1 month ago
D) as SYS in both the databases? Really? That's like giving the keys to the kingdom to a complete stranger. No, thanks!
upvoted 0 times
...
Cristina
1 month ago
B) as SCOTT in BOSTON_DB is the correct answer. Why would I want to access SCOTT in DALLAS_DB from anywhere else? That's just asking for trouble.
upvoted 0 times
...
Mary
2 months ago
I feel like it has to be B, but I also recall something about needing permissions from both databases. What if it's A?
upvoted 0 times
...
Glenna
2 months ago
I’m a bit confused about whether SYS access is necessary in DALLAS_DB for this scenario. Could it be C?
upvoted 0 times
...
Zita
2 months ago
I remember a similar question where we had to create a database link, and it was important to use the correct user context. Maybe it's B?
upvoted 0 times
...
Kyoko
2 months ago
I think the command needs to be executed as SCOTT in BOSTON_DB, but I'm not entirely sure if that's the only requirement.
upvoted 0 times
...
Janine
2 months ago
Okay, I think I've got it. The command is creating a database link, so it needs to be executed by SCOTT in BOSTON_DB in order to give SCOTT in BOSTON_DB access to the SCOTT schema in DALLAS_DB. B) seems like the right answer.
upvoted 0 times
...
Celestina
2 months ago
I think the key here is that the command is creating a database link, so the user executing the command matters. My guess is that the correct answer is B) as SCOTT in BOSTON_DB.
upvoted 0 times
...
Lavera
3 months ago
I'm a bit confused by the multiple databases and tnsnames.ora files. I'll need to review the details carefully to make sure I understand the setup before I try to answer this.
upvoted 0 times
...
Carolann
3 months ago
Okay, let's see. The question is asking how to execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB. That means we need to consider the user accounts and where the command is executed.
upvoted 0 times
...
Lavera
3 months ago
Hmm, this seems like a tricky one. I'll need to think carefully about the different user accounts and database connections.
upvoted 0 times
...

Save Cancel