Which two statements are true about conditional INSERT ALL? (Choose two.)
Which two statements are true about conditional INSERT ALL? (Choose two.)
In a conditional INSERT ALL statement, a single WHEN condition can indeed be used for multiple INTO clauses, enabling the same condition to insert data into multiple tables if needed. This makes choice B correct. Additionally, each WHEN condition is tested for each row returned by the subquery, as the evaluation of conditions occurs for each row fetched by the subquery, making choice C correct as well.
BC are correct https://oracle-base.com/articles/9i/multitable-inserts
A,c are correct