You create the following table, which lists how many books you have on loan to your friends.
Harry in San Francisco returns your books.
Which statement will update your table correctly?
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 120
Show AnswerHide Answer
Correct Answer: A
To correctly update the number of books to 0 for Harry in San Francisco, you need to ensure that both the name and the city match the criteria. Option A uses the correct SQL syntax to update the number of books for Harry in San Francisco by using the condition WHERE (Name = 'Harry' AND City = 'San Francisco'). This ensures that the specific record is accurately identified and updated.
Discussion
1 commentdongboy
Dec 16, 2021harry is not in san francisco but ok