Question $51$

You want to create a view that when queried will display the name, customer identification number, new balance, finance charge, and credit limit of all customers. When queried, the display should be sorted by credit limit from highest to lowest, then by the last name alphabetically. The view definition should be created regardless of the existence of the CUSTOMER and ACCOUNT tables. No DML may be performed when using this view. Evaluate these statements:

CREATE OR REPLACE FORCE VIEW CUST$\_$CREDIT$\_$V

AS SELECT c$.$last$\_$name, c$.$first$\_$name, c$.$customer$\_$id$,$ a$.$new$\_$balance, a$.$finance$\_$charge,

a$.$credit$\_$limit

FROM customer c$,$ account a

WHERE c$.$account$\_$id $=$ a$.$account$\_$id

WITH READ ONLY;

SELECT $*$FROM cust$\_$credit$\_$v ORDER BY credit$\_$limit DESC, last$\_$name;

Which statement is true?

A$.$

When both statements are executed, all of the desired results are achieved.

B$.$

The CREATE VIEW statement will fail because a view may not be created on tables that do not exist or are not accessible by the user.

C$.$

The statements will not return all of the desired results because the WITH CHECK OPTION clause is not included in the CREATE VIEW statement.

D$.$

To achieve all of the desired results this ORDER BY clause should be added to the CREATE VIEW statement: ORDER BY a$.$credit$\_$limit DESC, c$.$last$\_$name.