Examine these commands: Which two statements are true about the sqlldr execution? (Choose two.)

The correct answer is B. It uses the database buffer cache to load data D. It generates a sql script that it uses to load data from EMP.DAT to EMP. See the full explanation below for the reasoning.

Perform Database Maintenance

Question

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

Exhibit

Options

AIt overwrites data in EMP with data in EMP.DAT
BIt uses the database buffer cache to load data
CIt generates a log that contains control file entries, which can be used with normal SQL*Loader
DIt generates a sql script that it uses to load data from EMP.DAT to EMP
EIt appends data from EMP.DAT to EMP

How the community answered

(29 responses)

A
17% (5)
B
72% (21)
C
3% (1)
E
7% (2)

Topics

#SQL*Loader#sqlldr#direct path load#conventional path

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice