Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-082

Question #: 34
Topic #: 1

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

Suggested Answer: B 🗳️

by you1234 at June 23, 2020, 8:34 a.m.

Comments

Submit Cancel

NowOrNever

Highly Voted 3 years, 10 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, 9 months ago

B is correct.

upvoted 6 times

Phat

3 years, 5 months 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 8 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

9 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, 6 months 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, 6 months 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, 6 months ago

upvoted 1 times

...

LeandroHPN

1 year, 11 months ago

Selected Answer: B

B is correct

upvoted 1 times

...

Franky_T

2 years, 1 month 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, 5 months ago

B is correct

upvoted 1 times

...

Rivaldo11

3 years, 11 months ago

How do you know that user SCOTT lacks "create database link" privilege? I would say B.

upvoted 2 times

ama

3 years, 10 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, 6 months 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, 11 months ago

ama, D is correct?

upvoted 2 times

...

you1234

3 years, 11 months ago

B is correct? any suggestion

upvoted 4 times

Ekos

3 years, 6 months ago

agree, B is correct

upvoted 2 times

...

ama

3 years, 11 months ago

easy, SCOT User lacks the "create database link" privilege so B is wrong!

upvoted 1 times

ESK

1 year, 7 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

...