Examine these commands: Which two statements are true about the sqiidr execution?

The correct answer is A. It generates a sqi script that it uses to load data from EMP.DAT TO EMP. C. It appends data from EMP.DAT TO EMP. See the full explanation below for the reasoning.

Manage Schema Objects

Question

Examine these commands:

Which two statements are true about the sqiidr execution?

Exhibit

Options

AIt generates a sqi script that it uses to load data from EMP.DAT TO EMP.
BIt overwrites the data for Alan and adds data for Curl and Bob
CIt appends data from EMP.DAT TO EMP.
DIt overwrites all data in emp with data from emp.dat.
EIt generates a log that contains control file entries, which can be used with normal SQL'Loader

How the community answered

(30 responses)

A
77% (23)
B
13% (4)
D
3% (1)
E
7% (2)

Topics

#SQL*Loader#data loading#control file#INSERT mode

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice