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.
B and C are wrong, the title says file is too large and can not be loaded into the database.
A is not right, this is a flat file, not a database file can not be accessed by db link.
You can only use external tables to access.
Advantages of the external table
• The data can be used directly or in an external file to load data into another database.
• You can simultaneously query external data tables and databases reside, and can be connected directly to external data in a database table and, without having to load external data.
Data files created for the external table is movable data files can be used the same database or a different database tables in another external data files. Can query external data tables and databases reside, and external data in the database tables directly coupled, without first loading external data. Choose your application to use the SELECT command to directly access external tables, can also choose to load a data into the target database.
A flat file refers to data files that contain records with no structured relationships. Flat files may contain only basic formatting, have a small fixed number of fields, and it may or may not have a file format.