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 用户可以导出自己的模式

目录
相关文章
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 ...
2844 0
OCP-052考试题库汇总(57)-CUUG内部解答版
Examine these facts about a databases: 1.USERS is the database default tablespace. 2.USER1,USER2,and USER3 have the CREATE SESSION privilege 3.
763 0
|
数据库管理
OCP-052考试题库汇总(46)-CUUG内部解答版
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Whi...
789 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.
8272 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'...
819 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.
680 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.
1061 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.
640 0
OCP-052考试题库汇总(27)-CUUG内部解答版
Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.
538 0
|
机器学习/深度学习 Oracle 关系型数据库
OCP-052考试题库汇总(25)-CUUG内部解答版
Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Oracle Loader type external table E)An empty table F)A view selecting from an empty table G)An Oracle Data Pump type external table Answer: BDFG 赵:视图和外部表不存在段。
752 0