Oracle Database SQL — Question 254

Which two statements are true about conditional INSERT ALL? (Choose two.)

Answer options

• A. Each row returned by the subquery can be inserted into only a single target table.
• B. A single WHEN condition can be used for multiple INTO clauses.
• C. Each WHEN condition is tested for each row returned by the subquery.
• D. It cannot have an ELSE clause.
• E. The total number of rows inserted is always equal to the number of rows returned by the subquery.

Correct answer: B, C

Explanation

Option B is correct because a single WHEN condition can indeed be applied to multiple INTO clauses in a conditional INSERT ALL statement. Option C is also correct as each WHEN condition is evaluated for every row returned by the subquery, ensuring appropriate handling based on the conditions set. The other options either misrepresent how conditional INSERT ALL operates or state incorrect limitations.