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.

B)Use an Oracle Loader type External table.

C)Use an Oracle Data Pump type External table.

D)Use a CLOB column in a table to access the flat file.

E)Use a LONG RAW column in a table to access the flat file.

Answer: AB

赵：

外部表可以实现通过数据库对象直接访问目录文件里的格式数据，加载方式分为两种 oracle_loader 和oracle_datapump。oracle_loader 方式通过 sqlldr 引擎方式加载，访问 flat 格式文件;oracle_datapump通过 datapump 接口来加载，访问通过 oracle_datapump 方式加载的 dmp 文件;