【第35题】2019年OCP认证12C题库062考试最新考试原题-35

35、choose three

Which three statements are true about Oracle Data Pump?

A) Oracle Data Pump export and import operations can be performed to move data across different database releases.

B) Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.

C) Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D) DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.

E) A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

Answer:ADE

(解析:数据泵工具是一个非常灵活的数据迁移工具,可以支持不同的数据库版本;在导出的时候directory必须是当前存在的,同时要有读写的权限,在expdp时可以不指定directory目录,但是需要指定dumpfile=ocm_dir:emp.dmp logfile=ocm_dir:emp.log;远程的客户端可以导出服务器数据库的表,但是导出来的dump文件是放在服务器端的目录下,而不是客户端的目录下,因为directory制定的是服务器端的目录,而不是客户端的目录。来自3组:1015267481)

原文地址:https://www.cnblogs.com/cnblogs5359/p/10906170.html