Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

What is Private Database Link in Oracle?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?What is Data Block in Oracle Architecture?