YOU HAVE CREATED A CUSTOMERS TABLE AND AN NZCUSTOMERS VIEW USING T...

10. You have created a Customers table and an NZCustomers view using the following definitions.…

CREATE TABLE Customers

(CustomerID int IDENTITY PRIMARY KEY,

CompanyName varchar(50),

Country varchar(50),

Notes varchar(max));

GO

CREATE VIEW NZCustomers AS

SELECT * FROM Customers WHERE Country = 'New Zealand';

CREATE TRIGGER Trig_NZCustomers

ON dbo.NZCustomers INSTEAD OF INSERT

AS

BEGIN

SELECT CustomerID FROM INSERTED

END

You notice that when you insert data into the NZCustomers view, no error occurs, but the data does not appear in the table. What is the cause of the problem?A. The Trig_NZCustomers must be dropped because it is preventing the insert operation.B. The view cannot be updated because of the WHERE clause. Remove the WHERE clause from the view.C. The IDENTITY column is preventing new CustomerIDs from being generated. Redefine the column not to use the IDENTITY attribute.D. You must explicitly call COMMIT TRANSACTION within Trig_NZCustomers.