【第36题】2019年OCP认证12C题库062考试最新考试原题
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用户的对象。来自3组:1015267481)