You have created a view that your users need to use to update records in one of your tables. The code to create the view looks like this:

CREATE VIEW ProductCost WITH SCHEMABINDING AS

SELECT ProdID, Cost, Qty, SUM(qty * cost) FROM Products

What do you need to change on this view to make it updateable?

A. Nothing, the view is updateable as is.

B. Change the code to look like this:

CREATE VIEW ProductCost AS

SELECT ProdID, Cost, Qty, SUM(qty * cost) FROM Products

C. Change the code to look like this:

CREATE VIEW ProductCost WITH ALLOWAGREGATES AS

SELECT ProdID, Cost, Qty, SUM(qty * cost) FROM Products

D. Change the code to look like this:

CREATE VIEW ProductCost WITH SCHEMABINDING AS

SELECT ProdID, Cost, Qty FROM Products