Oracle Exam 1Z0-062 Topic 8 Question 32 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 32
Topic #: 8

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?

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

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

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

DORCL2 database link creation fails.

Show Suggested Answer

Suggested Answer: C

by Rory at May 07, 2022, 11:36 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!