What is the outcome of executing these commands in the ORCL1 database?

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/SALES123CREATE DATABASE LINK orc12 USING ‘orc12’;What is the outcome of executing these commands in the ORCL1 database?

Question:

What is the outcome of executing these commands in the ORCL1 database?

Options:

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

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

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

ORCL2 database link creation fails.

Correct Answer

The Correct Answer for this Question is

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

You may also like...

Leave a Reply

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