2018年的時(shí)候，OCP 11g考試題庫(kù)大更新，052 053出現(xiàn)了很多新題，

2019年，11g即將停考的前期，Oracle又出現(xiàn)了一次大變動(dòng)，12c出現(xiàn)了很多新題，比如062 063題庫(kù)大更新

OCP解析公開(kāi)課時(shí)間：【每周五晚8點(diǎn)】

OCP解析公開(kāi)課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗(yàn)證：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

(解析：該創(chuàng)建dblink的命令創(chuàng)建了一個(gè)connect user的dblink，因?yàn)闆](méi)有指定public，而且是sales用戶(hù)創(chuàng)建的，所以只有orcl1數(shù)據(jù)庫(kù)的sales用戶(hù)能夠訪問(wèn)orcl2數(shù)據(jù)庫(kù)上的sales用戶(hù)的對(duì)象。)