Which can be used in scenario where there are large data loads of a sensitive nature into a data
warehouse?
A.
Direct path loading
B.
External tables for loading flat files
C.
Partition exchange loading
D.
Any of these are valid for certain situations.
Explanation:
Instead of filling a bind array buffer and passing it to the Oracle database with a
SQL INSERT statement, a direct path load uses the direct path API to pass the data to be loaded
to the load engine in the server. The load engine builds a column array structure from the data
passed to it.
The direct path load engine uses the column array structure to format Oracle data blocks and build
index keys. The newly formatted database blocks are written directly to the database (multiple
blocks per I/O request using asynchronous writes if the host platform supports asynchronous I/O).
Internally, multiple buffers are used for the formatted blocks. While one buffer is being filled, one or
more buffers are being written if asynchronous I/O is available on the host platform. Overlapping
computation with I/O increases load performance.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1008815