O'Reilly logo

Developing and Implementing Windows®-Based Applications with Visual C#™ .NET and Visual Studio® .NET Exam Cram™ 2 (Exam 70-316) by Priti Kalani, Amit Kalani, Kalani Kirk Hausman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required