【OCP 12c】2019年OCP题库062新出现的考题-第36题

文章来源：更新时间:2019/5/14 13:19:43

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，

2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：1015267481 验证：ocp

-------------------------------------------------------

36、choose one

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/SALES123

CREATE DATABASE LINK orc12 USING 'orc12';

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

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

B) ORCL 2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.

C) ORCL2 database link creation fails.

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

Answer：A

(解析：该创建dblink的命令创建了一个connect user的dblink，因为没有指定public，而且是sales用户创建的，所以只有orcl1数据库的sales用户能够访问orcl2数据库上的sales用户的对象。)