Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 179

Which two are true about multitable INSERT statements?

    Correct Answer: A, C

    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.

Discussion
musafirOptions: CE

CE are correct B I think is correct as well?

ArslanAltaf

No ,you can specify the columns from and into so it does not necessarily have to be the same.

lucemqyOptions: CE

CD is correct