Which is the most effective method to accomplish the task?

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?

A.
Load the data into your database by using the PARALLEL clause.

B.
Upgrade the hardware/memory to accommodate the data.

C.
Use an external table so you can have the metadata available in your database, but leave the data in the operating system files.

D.
Give analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.



Leave a Reply 0

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