What is the outcome of executing these commands in the …

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.
User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.
Examine these commands:
Conn SALES/SALES123
CREATE DATABASE LINK orcl2 USING ‘orcl2’;
What is the outcome of executing these commands in the ORCL1 database? (Choose the best answer)

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.
User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.
Examine these commands:
Conn SALES/SALES123
CREATE DATABASE LINK orcl2 USING ‘orcl2’;
What is the outcome of executing these commands in the ORCL1 database? (Choose the best answer)

A.
ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.

B.
ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.

C.
ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

D.
ORCL2 database link creation fails.

Explanation:

Show Hint

Leave a Reply 5

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

LDA

LDA

anyone tested?

I think the syntax is wrong, so answer is D?

Reply

Test123

Test123

I tested and it worked. Did you gave Sales the CREATE DATABASE LINK and CREATE SESSION privileges?

Reply

LDA

LDA

yeah, answer is C

😀

Reply