1z0-071 Exam QuestionsBrowse all questions from this exam

1z0-071 Exam - Question 179


Which two are true about multitable INSERT statements?

Show Answer
Correct Answer: ACE

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

2 comments
Sign in to comment
musafirOptions: CE
Jun 27, 2023

CE are correct B I think is correct as well?

ArslanAltaf
May 4, 2024

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

lucemqyOptions: CE
Nov 16, 2023

CD is correct