Oracle Database SQL — Question 147

Which two are true about multitable INSERT statements?

Answer options

• A. The conditional INSERT FIRST statement always inserts a row into a single table.
• B. The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.
• C. They can transform a row from a source table into multiple rows in a target table.
• D. The conditional INSERT ALL statement inserts rows into a singe table by aggregating source rows.
• E. They always use subqueries.

Correct answer: C, E

Explanation

Option C is correct because multitable INSERT statements can indeed convert a single source row into multiple target rows. Option E is also correct as these statements typically rely on subqueries to select data. The other options are incorrect as they misrepresent the behavior of INSERT FIRST, INSERT ALL, and the necessity of using subqueries.