052-95

You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.
Which is the most effective method to access this data in your database?
A.Use the database link.
B.Use the SQL*Loader utility.
C.Use the Oracle Data Pump utility.
D.Create an external table and leave the data in the flat file.

　　因为题目中提到文件过大，不能导入到数据库中，故排除 BC，又因为数据存在平面文件中，不是数据库文件，故 A 也不可行。答案选择 D，使用外部表来访问

转载于:https://www.cnblogs.com/Babylon/p/8022851.html