ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-082
Question #: 34
Topic #: 1
[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?

  • A. as SCOTT in DALLAS_DB
  • B. as SCOTT in BOSTON_DB
  • C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
  • D. as SYS in both the databases
  • E. as SCOTT in both the databases
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by you1234 at June 23, 2020, 8:34 a.m.

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
Submit Cancel
NowOrNever
Highly Voted 3 years, 5 months ago
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
upvoted 15 times
...
avanand
Highly Voted 3 years, 4 months ago
B is correct.
upvoted 6 times
Phat
3 years ago
agree. if Scott create the link, only Scott can use it. to access dallas_db from boston_db, Scoot has to create the private link from boston_db.
upvoted 2 times
...
...
nautil2
Most Recent 3 months, 1 week ago
Selected Answer: B
A - FALSE; source database is BOSTON_DB, in that db the database link must be created B - TRUE; source database is BOSTON_DB and owner is SCOTT => private database link is created C - FALSE; correct private dblink is created, but also SYS in DALLAS_DB can access to SCOTT schema D - FALSE; both db links are accessible only to SYS users in both databases E - FALSE; both SCOTT in BOSTON_DB and SCOTT in DALLAS_DB can access SCOTT schema in DALLAS_DB
upvoted 1 times
...
Hell3n
4 months, 1 week ago
Selected Answer: B
https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085
upvoted 1 times
...
alan_resende
1 year, 1 month ago
I think B is correct. You must execute the statement connected to scott in boston_db to create a private db link. so, to access scott schema in dallas_db.
upvoted 1 times
...
Minoro
1 year, 1 month ago
Db link was created at SCOTT/BOSTON_DB, So scott/Boston_db can access Scott/Dallas_db, using dblink @db_link ... and scott/Boston_db can access the objects due to it is the owner ... Letter E ... Scott in both databases
upvoted 1 times
...
Minoro
1 year, 1 month ago
Db link was created at SCOTT/BOSTON_DB, So scott/Boston_db can access Scott/Dallas_db, using dblink @db_link ... and scott/Boston_db can access the objects due to it is the owner ... So for me letter C can access the SCOTT schema in DALLAS_DB?
upvoted 1 times
...
LeandroHPN
1 year, 6 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
Franky_T
1 year, 8 months ago
Selected Answer: B
Firstly, there is no reference to Scott's permissions, so we have to assume that Scott has the ability to create the DB Link. A is wrong. DALLAS_DB is the target, so the link has to be created from the source which is BOSTON_DB. B is correct. Source and target is correct and this has to be a private link only accessible to Scott. C is wrong. This link is one-directional and only needs to be done from BOSTON_DB. D is wrong. DB Links created by SYS becomes publicly available, we only want Scott to access this link. E is wrong. Just silly, we don't need a DB Link from a database to itself.
upvoted 2 times
...
ryuah
2 years ago
B is correct
upvoted 1 times
...
Rivaldo11
3 years, 6 months ago
How do you know that user SCOTT lacks "create database link" privilege? I would say B.
upvoted 2 times
ama
3 years, 5 months ago
this is the script for scott Schema... https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql i didn't find any create database link priveleges!
upvoted 2 times
SimoneF
3 years, 1 month ago
But if you create the DBLINK as SYS schema, SCOTT cannot access it. I think the question is not about the privileges of the schema, which is more in a hypothetical situation where the privilege is there, while rather on the functioning of dblinks.
upvoted 2 times
...
...
...
you1234
3 years, 6 months ago
ama, D is correct?
upvoted 2 times
...
you1234
3 years, 6 months ago
B is correct? any suggestion
upvoted 4 times
Ekos
3 years, 1 month ago
agree, B is correct
upvoted 2 times
...
ama
3 years, 6 months ago
easy, SCOT User lacks the "create database link" privilege so B is wrong!
upvoted 1 times
ESK
1 year, 2 months ago
They don't indicate the rights SCOTT has, i therefore don't think they have any bearing on the question. I think it is about how the the link is created though.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago