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

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

Answer: D

Latest 1Z0-082 Dumps Valid Version with 90 Q&As

Latest And Valid Q&A | 90 Days Free Update | Once Fail, Full Refund

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>