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.

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.

B)It allows encryption to be performed without using a password.

C)It supports the export of specific views as tables.

D)It allows compression levels to be defined for the export.

E)It supports the renaming of tables during import.

Answer: DE

赵:AE=>DE

A 译:如果导出操作中使用的目录有现有的转储文件,则会覆盖这些文件。

D 译:它允许为导出定义压缩级别。

11g expdp 工具支持压缩和加密功能,但是加密的时候需要用到密码。压缩的方式分别 是 ALL,DATA_ONLY, METADATA_ONLY,DEFAULT 或 NONE。默认是会采用 DEFAULT 的压缩方式采用METADATA_ONLY 级别压缩。加密的级别是 ALL,DATA_ONLY,METADATA_ONLY,ENCRYPTED_COLUMNS_ONLY 或 NONE。设置参数 REUSE_DUMPFILES 覆盖目标转储文件 (如果文件存在) (N)。

冉:这个就是文字游戏了,A 和 D 都有参数支持,但 D 答案用了一个 allow,比 A 答案更好。仔细看E 答案,同理,用了一个 supports。选 DE 吧。

赵:A 错,如果导出时没有使用 REUSE_DUMPFILES=Y 这个参数,且已经有同名文件存在,将报错ORA-27038: created file already exists。

网友选 AE,按冉老师的来。

目录
相关文章
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 ...
768 0
OCP-052考试题库汇总(55)-CUUG内部解答版
Examine these facts about a database: 1.USER is the database default tablespace. 2.USER1, USER2, and USER3 have the CREATE SESSION privilege.
3048 0
|
Oracle 关系型数据库 数据库管理
OCP-052考试题库汇总(47)-CUUG内部解答版
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘s best practices.
821 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...
770 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(45)-CUUG内部解答版
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file.
1862 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.
732 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.
512 0
|
数据库
OCP-052考试题库汇总(26)-CUUG内部解答版
Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。
676 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 赵:视图和外部表不存在段。
734 0
|
存储 数据库
OCP-052考试题库汇总(21)-CUUG内部解答版
Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer.
2710 0

热门文章

最新文章