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…

The correct answer is B. database link. 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…

Oracle Database 12c Architecture

Question

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?

Options

Acluster
Bdatabase link
Cmapping table
Dmaterialized view

How the community answered

(51 responses)

A
4% (2)
B
80% (41)
C
10% (5)
D
6% (3)

Explanation

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.

Topics

#database link#remote database access#schema objects#distributed database

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice