Practice Questions

Question 1You need to modify the data present in the Customers table to increase the Discount rate by 5%. Which type of SQL statement should you use for this purpose?

  • A. DELETE

  • B. INSERT

  • C. SELECT

  • D. UPDATE

A1: Answer D is correct. SQL UPDATE statements are used to modify existing data. Answer A is incorrect because DELETE statements are used to remove existing data rather than change it. Answer B is incorrect because the INSERT statement is used to add new records. The SELECT statement is used to return existing data records, not to change them, making answer C incorrect as well.
Question 2Given the following code, what order will the final record set be in? 
 SELECT Count(CustomerID) as CustCount, State FROM [Customer Data] GROUP ...

Get Developing and Implementing Windows®-Based Applications with Visual C#™ .NET and Visual Studio® .NET Exam Cram™ 2 (Exam 70-316) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial