Which schema object enables the user to access the information from the remote database?

You have two database servers EMP and EXP. A user of the database from the EXP server wants
to extract some information from the database in the EMP server for cross-verification. Which
schema object enables the user to access the information from the remote database?

You have two database servers EMP and EXP. A user of the database from the EXP server wants
to extract some information from the database in the EMP server for cross-verification. Which
schema object enables the user to access the information from the remote database?

A.
cluster

B.
database link

C.
mapping table

D.
materialized view

Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

Show Hint

Leave a Reply 2

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

Sunil Vora

Sunil Vora

https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205

CREATE DATABASE LINK
Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.
After you have created a database link, you can use it in SQL statements to refer to tables, views, and PL/SQL objects in the other database by appending @dblink to the table, view, or PL/SQL object name. You can query a table or view in the other database with the SELECT statement. You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement.

Reply