Question: You create the following table named LoanedBooks, which lists how many books you have on loan to your friends. ID Name City Books Harry New

You create the following table named LoanedBooks, which lists how many books you have on loan to your friends. ID Name City Books Harry New York 2 2 Sally San Francisco 3 3 Sue Chicago 0 4 Harry San Francisco 3 5 William Detroit Harry in San Francisco returns your books. Which statement will correctly update your table? UPDATE LoanedBooks O A. SET Books = 0 WHERE (Name In 'Harry' , 'San Francisco' ) INSERT INTO LoanedBooks O B. SET Books = 0 WHERE ID = 4 UPDATE LoanedBooks O C. SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco') UPDATE LoanedBooks O D. SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco' )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The antenna tower is supported by three cables. If the forces of these cables acting on the antenna are FB = 520 N, FC = 680 N, and FD = 560 N, determine the magnitude and coordinate direction angles...

Published by CQ Press, an Imprint of SAGE Publications, Inc. www.cqresearcher.com Future of Cars Are Americans ready for self-driving vehicles? C ars that drive themselves, long a staple of science...

. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on a...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

These are what my teacher expects for a strategic analysis essay: "Strategic Case Analyses - Case studies provide important windows into the real problems that firms are trying to solve. Note, since...

english literature - explain how the literary theory connects to your interpretation speak kn it in depth with textual evidence ans resoning. choose 7 quotes and explain it in your words JOHN...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Cedar Fair CaseCompanion Case to Six Flags CaseFrom 1998-2006 there were four large, well-funded competitors in the regional theme park industry. Inorder: Six Flags, Cedar Fair, Paramount Parks, and...

Would you or the gas company gain by having gas warmed before it passed through your gas meter?

The number of automobiles that arrive at a certain intersection per minute has a Poisson distribution with a mean of 5. Interest centers around the time that elapses before 10 automobiles appear at...

Consider the following data for a particular sample period: \ table [ [ , Portfolio P , Market Index, M ] , [ Average return, 3 5 % , 2 8 % ] , [ Beta , 1 . 2 0 , 1 . 0 0 ] , [ Standard deviation, 4...

Discuss qualitative research designs in detail?