052-93

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.
While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?
A.Use the external table population.
B.Use the Oracle Data Pump export and import utility.
C.Use the conventional path data load of the SQL*Loader utility.
D.Use the INSERT INTO...SELECT command to load the data.

  这里说的 flat files,是一种包含没有相对关系结构的记录的文件。这个类型通常用来描述文字处理、其他结构字符或标记被移除了的文本,也就是比如文本文件,或者 csv 文件等,这种类型的文件如果想导入数据库直接用SQL*Loader


posted @ 2017-12-11 14:02  巴啦啦大魔王  阅读(151)  评论(0编辑  收藏  举报