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.
答案:C
解析:这里说的flat files,是一种包含没有相对关系结构的记录的文件。这个类型通常用来描述文字处理、其他结构字符或标记被移除了的文本,也就是
比如文本文件,或者csv文件等,这种类型的文件如果想导入数据库直接用SQL*Loader
直接在sqlplus中执行sqlldr就可以看到帮助
[oracle@wahaha3 trace]$ sqlldr
SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jul 23 17:31:24 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Usage: SQLLDR keyword=value [,keyword=value,...]
....................
........省略........
....................
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.
答案:C
解析:这里说的flat files,是一种包含没有相对关系结构的记录的文件。这个类型通常用来描述文字处理、其他结构字符或标记被移除了的文本,也就是
比如文本文件,或者csv文件等,这种类型的文件如果想导入数据库直接用SQL*Loader
直接在sqlplus中执行sqlldr就可以看到帮助
[oracle@wahaha3 trace]$ sqlldr
SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jul 23 17:31:24 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Usage: SQLLDR keyword=value [,keyword=value,...]
....................
........省略........
....................