For conditional INSERT ALL in Oracle Database 12c:
* D. A single WHEN condition can be used for multiple INTO clauses. This is true. A single WHEN condition in a multi-table insert can direct the insertion of a single row source into multiple target tables.
* E. Each WHEN condition is tested for each row returned by the subquery. True, each row from the subquery is evaluated against each WHEN condition to determine into which table(s) the row should be
* inserted.
Options A, B, and C are incorrect:
* A is incorrect because a row can indeed be directed into multiple tables based on the conditions.
* B is incorrect as INSERT ALL can include an ELSE clause to handle rows that do not meet any of the specified conditions.
* C is incorrect because not every row from the subquery necessarily results in a row insertion; it depends on the conditions being met.