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

简介: Which two can be exported by a non-administrative account by using Data Pump?A)directory objectsB)tablesC)tablespacesD)schemasE)databaseAnswer: BD赵:EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。

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 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。

EXPDP 和 IMPDP 是服务端的工具程序,他们只能在 ORACLE 服务端使用,不能在客户端使用。

IMP 只适用于 EXP 导出的文件,不适用于 EXPDP 导出文件;IMPDP 只适用于 EXPDP 导出的文件,而不适用于 EXP 导出文件。

expdp 或 impdp 命令时,可暂不指出用户名/密码@实例名 as 身份,然后根据提示再输入,如: expdp schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata1;

调用 EXPDP 使用 EXPDP 工具时,其转储文件只能被存放在 DIRECTORY 对象对应的 OS 目录中,而不能直接指定转储文件所在的 OS 目录.

因此,使用 EXPDP 工具时,必须首先建立 DIRECTORY 对象.并且需要为数据库用户授予使用 DIRECTORY 对象权限.

小明:

B 用户可以导出自己的表

D 用户可以导出自己的模式

目录
相关文章
|
数据安全/隐私保护 关系型数据库 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...
3764 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 ...
2860 0
OCP-052考试题库汇总(58)-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 ...
806 0
|
SQL 数据库 关系型数据库
OCP-052考试题库汇总(43)-CUUG内部解答版
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes.
2161 0
OCP-052考试题库汇总(42)-CUUG内部解答版
You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2'...
833 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.
779 0
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(35)-CUUG内部解答版
Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.
737 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(32)-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...
747 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.
834 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(29)-CUUG内部解答版
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.
1072 0