This question is based on successful execution of the following command:

CREATE VIEW changename

AS SELECT customer#, lastname, firstname

FROM customers

WITH CHECK OPTION;

Assume that the only constraint on the CUSTOMERS table is a PRIMARY KEY constraint.

If the CHANGENAME view needs to include the customer’s zip code as a means of verifying the change (that is, to authenticate the user), which of the following is true?

a. The CREATE OR REPLACE VIEW command can be used to re-create the view with the necessary column included in the new view.

b. The ALTER VIEW…ADD COLUMN command can be used to add the necessary column to the existing view.

c. The CHANGENAME view can be dropped, and then the CREATE VIEW command can be used to re-create the view with the necessary column included in the new view.

d. All of the above can be performed to include the customer’s zip code in the view.

e. Only a and b include the customer’s zip code in the view.

f. Only a and c include the customer’s zip code in the view.

g. None of the above includes the customer’s zip code in the view.