You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.
Which statement should you use?
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 57
Show AnswerHide Answer
Correct Answer: B
To insert two new products into the Product table, the correct SQL statement should specify the columns and their corresponding values for each row insertion separately. Option B does exactly that, with two separate INSERT INTO statements, each inserting one product with its ID and Name. This ensures each product is added to the Product table with the correct details.
Discussion
1 commentDamZ
Aug 17, 2020I like how there isn't an option for E. XD
WildRubis
Jan 29, 2021XDDDDDD
hajimammad
Nov 10, 2021hahahaha