Question

According to the SQL-92, statements used to construct views cannot contain ________.

1) the SELECT clause
2) the FROM clause
3) the WHERE clause
4) the ORDER BY clause
5) SQL view statements can use all of the listed clauses.

Answer 1

SQL views created under SQL-92 standards cannot contain the ORDER BY clause; however, SELECT, FROM, and WHERE clauses are allowed.

Step-by-step explanation:

The question is addressing SQL view creation restrictions according to the SQL-92 standard. The correct answer is that statements used to construct views cannot contain the ORDER BY clause. In a view definition, according to SQL-92 standard, the SELECT, FROM, and WHERE clauses are permissible, but the ORDER BY clause is not allowed because the view is supposed to represent a virtual table and the concept of ordering does not apply here as it does in the result set of a select query. Therefore, option 4) the ORDER BY clause is the correct answer.