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?
A.
UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')
B.
UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')
C.
UPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')
D.
INSERT INTO LoanedBooks SET Books = 0 WHERE ID =
Suggested Answer:A🗳️
The row must match both name and city. Incorrect Answers: B: The row must match both name and city. Therefore we must use AND and not OR. C: Incorrect syntax in the WHERE clause. D: This would work, but we'd need to lookup the ID first. References: https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-2017
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dongboy
3 years, 4 months ago