View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables. Which is the best method to load data from the MARKS_DETAILStable to the MARKStable?

The correct answer is A. Pivoting INSERT. See the full explanation below for the reasoning.

Question

Exhibit

Options

APivoting INSERT
BUnconditional INSERT
CConditional ALL INSERT
DConditional FIRST INSERT

How the community answered

(33 responses)

A
76% (25)
B
3% (1)
C
9% (3)
D
12% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice