Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

The correct answer is A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions. C. Parallelizing loads with external tables enables more efficient space management. Parallelizing loads with external tables enables a more efficient space management compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

Performance Optimization

Question

Options

ATransformations can be applied directly on the file data using SQL or PL/SQL constructions.
BExternal tables allow transparent parallelization inside the database.
CParallelizing loads with external tables enables more efficient space management.
DExternal tables can take advantage of storage indexes to speed up data loads.

How the community answered

(34 responses)

A
79% (27)
B
15% (5)
D
6% (2)

Explanation

Parallelizing loads with external tables enables a more efficient space management compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

Topics

#external tables#SQL*Loader#parallel data loads#space management

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice