OCP-052考试题库汇总(42)-CUUG内部解答版

简介: You successfully executed these commands:connect scott/tiger@prod1;CREATE DATABASE LINK db_prod2CONNECT TO scott IDENTIFIED BY tigerUSING 'PROD2'...

You successfully executed these commands:

connect scott/tiger@prod1;

CREATE DATABASE LINK db_prod2

CONNECT TO scott IDENTIFIED BY tiger

USING 'PROD2';

Which type of database link is created?

A)private current user database link

B)public connected user database link

C)public current user database link

D)private fixed user database link

E)public fixed user database link

Answer: D

赵:

总结:

默认创建的是 private connect,create 子句中没有这两个关键字,是 private connected 类型的;

Create 子句中有 public 关键字的是 public 类型的;

Create 子句中有 current_user 关键字的是 current 类型的;

Create 子句中有 identified by 关键字的是 fixed 类型的;

资料:blog-itpub-net/31397003/viewspace-2137245/

PDF 上有个表格没复制过来。

CREATE SHARED database link link_name

CONNECT TO [user IDENTIFIED BY password]

[AUTHENTICATED BY user IDENTIFIED BY password]

[USING 'connect_string']

Dblink 分三类:用户级(private)、数据库级(public)、网络级。

默认情况下创建的是用户级(private)。

另参考:www-cnblogs-com/sumsen/archive/2013/03/04/2943471.html

几种类型DBLINK创建示例:

--Private connected user

CREATE database link

sales.us.americas.acme_auto.com USING ‘sales_us’;

--Private current user

CREATE database link foo

CONNECT TO CURRENT_USER USING ‘am_sls’;

--Private fixed user

CREATE database link

sales.us.americas.acme_auto.com

CONNECT TO scott IDENTIFIED BY tiger USING ‘sales_us’;

--Public fixed user

CREATE PUBLIC database link

sales CONNECT TO scott IDENTIFIED BY tiger USING ‘rev’;

--Shared public fixed user

CREATE SHARED PUBLIC database link

sales.us.americas.acme_auto.com

CONNECT TO scott IDENTIFIED BY tiger AUTHENTICATED BY

anupam IDENTIFIED BY bhide USING ‘sales’;

目录
相关文章
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(60)-CUUG内部解答版
Examine these facts about a database: The database default tablespace to EXAMPLE. DEFERRED_SEGMENT_CREATION is TRUE (原来为 FALSE,题目有错) Examine these co...
3762 0
OCP-052考试题库汇总(59)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
2859 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(49)-CUUG内部解答版
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
1016 0
|
SQL
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8286 0
|
SQL 数据库 关系型数据库
OCP-052考试题库汇总(43)-CUUG内部解答版
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes.
2159 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(39)-CUUG内部解答版
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.
777 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(33)-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database Answer: BD 赵: EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
680 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(31)-CUUG内部解答版
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.
830 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(30)-CUUG内部解答版
Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server.
703 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(28)-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.
652 0

热门文章

最新文章