|Question 1||You 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?
|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 2||Given the following code, what order will the final record set be in?
SELECT Count(CustomerID) as CustCount, State FROM [Customer Data] GROUP ...