OCP-1Z0-052-V8.02-136题

最新推荐文章于 2018-10-29 19:22:48 发布

Riveore

最新推荐文章于 2018-10-29 19:22:48 发布

阅读量7.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： OCP-1Z0-052 OCP11g解析

本文链接：https://blog.csdn.net/rlhua/article/details/14166479

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-052

198 篇文章

订阅专栏

本文介绍了一个使用数据库链接来实现跨数据库服务器数据访问的例子。场景涉及两个数据库服务器SEMP和SACCT，分别存储员工信息和应付账款信息。通过设置数据库链接，应付账款部门能够从SEMP服务器提取员工信息进行交叉验证。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

136. You have two database servers SEMP and SACCT. The database in the SEMP server maintains the

employee information and the database in the SACCT server maintains the accounts payable information.

The employees submit the expense reports to the accounts payable department. A user of the accounts

payable database wants to extract the employee information from the database in the SEMP 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

Answer: B

答案解析：

你有两个数据库服务器SEMP和SACCT。在SEMP服务器的数据库维护员工信息，在SACCT服务器的数据库维护应付帐款信息。

员工向应付帐款部门提交开销报告，应付账款数据库用户要从SEMP服务器的数据库提取员工信息从而进行交叉验证

What Are Database Links?

A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to the local database that contains the data dictionary entry.

A database link connection is one-way in the sense that a client connected to local database A can use a link stored in database A to access information in remote database B, but users connected to database B cannot use the same link to access data in database A. If local users on database B want to access data on database A, then they must define a link that is stored in the data dictionary of database B.

A database link connection allows local users to access data on a remote database. For this connection to occur, each database in the distributed system must have a unique global database name in the network domain. The global database name uniquely identifies a database server in a distributed system.