nerdexam
Oracle

1Z0-032 · Question #81

A single SQL*Loader input data file might contain records in a variety of formats. Click the Exhibit button and examine the data shown, in which EMP and DEPT records are intermixed (DEPT records are i

The correct answer is A. INTO TABLE dept C. INTO TABLE dept. See the full explanation below for the reasoning.

Question

A single SQL*Loader input data file might contain records in a variety of formats. Click the Exhibit button and examine the data shown, in which EMP and DEPT records are intermixed (DEPT records are indicated by 1 and EMP records are indicated by 2). Which two statements can you use to load the data shown in the Exhibit into the DEPT and EMP tables? (Choose two.)

Exhibit

1Z0-032 question #81 exhibit

Options

  • AINTO TABLE dept
  • BINTO TABLE emp
  • CINTO TABLE dept
  • DINTO TABLE emp

How the community answered

(30 responses)
  • A
    77% (23)
  • B
    10% (3)
  • D
    13% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice