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

CREATE VIEW changeaddress

AS SELECT customer#, lastname, firstname, order#,

shipstreet, shipcity, shipstate, shipzip

FROM customers JOIN orders USING (customer#)

WHERE shipdate IS NULL

WITH CHECK OPTION;

Which of the following is correct?

a. ROWNUM can’t be used with the view because it isn’t included in the results the subquery returns.

b. The view is a simple view because it doesn’t include a group function or a GROUP BY clause.

c. The data in the view can’t be displayed in descending order by customer number because an ORDER BY clause isn’t allowed when working with views.

d. All of the above

e. None of the above