Which two are true about multitable INSERT statements?
Which two are true about multitable INSERT statements?
The conditional INSERT FIRST statement always inserts a row into a single table, making this statement true. They can transform a row from a source table into multiple rows in a target table, which is another correct statement. The unconditional INSERT ALL statement does not require the same number of columns in both source and target tables. The conditional INSERT ALL statement does not necessarily insert rows by aggregating source rows, and multitable INSERT statements do not always use subqueries.
CE are correct B I think is correct as well?
No ,you can specify the columns from and into so it does not necessarily have to be the same.
CD is correct