1Z0-052 · Question #180
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
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #180. The question stem and answer options stay visible for context.
Question
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?
Options
- AUse the external table population.
- BUse the Oracle Data Pump export and import utility.
- CUse the conventional path data load of the SQL*Loader utility.
- DUse the INSERT INTO...SELECT command to load the data.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.