SQL statements used to construct views cannot contain ________.
A) the SELECT clause
B) the FROM clause
C) the WHERE clause
D) the ORDER BY clause
E) the LIKE keyword

Question

Quizplus · Accepted Answer

SQL statements used to construct views can include the SELECT, FROM, and WHERE clauses, and can use the LIKE keyword. However, they cannot contain the ORDER BY clause, as the order of rows in a view is not guaranteed. The ORDER BY clause is used when selecting data from the view, not when creating it.

SQL Statements Used to Construct Views Cannot Contain ________