Which of the following queries if any correctly

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: records from tables. • Question 5: Multiple Choice Average Score 1.49785 points Suppose we would like to discount books that cost more than $20 to $15. Which of the following queries, if any, correctly modifies the table? Correct Percent Answered UPDATE books SET Price = 15 WHERE Price > 20 UPDATE books WHERE Price > 20 SET Price = 15 18.24% ALTER books ADD Price = 15 WHERE Price > 20 2.575% No other answer choice will correctly modify the table. 4.292% Unanswered 74.893% 0% Kai Zhao 5/3/12 11:26 AM Comment [10]: SET has to appear before PRICE...
View Full Document

This document was uploaded on 02/17/2014 for the course CS 105 at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online