Q
In a conditional multitable insert, what does INSERT FIRST do?
-
A
Inserts the first row only
-
B
Inserts into all tables whose condition is true
-
C
Inserts each row only into the first table whose condition is true
-
D
Inserts rows in sorted order
Correct Answer:
C. Inserts each row only into the first table whose condition is true
Explanation:
INSERT ALL evaluates every WHEN clause; INSERT FIRST stops at the first true condition for each row.
