Exit 98-364 Database Fundamentals
Question 1 of 5
0% complete
Q1 Single choice

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 =

Previous Next