Although it cannot be used in creating an SQL VIEW,the SQL SELECT statements retrieving view instances can include ________.
A) SQL keyword ORDER BY
B) SQL keyword LIKE
C) SQL keyword BETWEEN
D) SQL keyword NULL
E) SQL keyword NOT NULL

Question

Quizplus · Accepted Answer

The SQL SELECT statement retrieving view instances can include the SQL keyword ORDER BY to specify the order in which the records should be displayed. However, the keywords LIKE, BETWEEN, NULL, and NOT NULL cannot be used in this context as the view has already been defined and cannot be modified through the SELECT statement.

Although It Cannot Be Used in Creating an SQL VIEW,the