Which is the most effective method to access this data in your database?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *