Multiple choice

Which of the following is not true of SQL views?

  1. Oracle views cannot use the ORDER BY clause in view definitions.

  2. Oracle views are created using the standard SQL-92 CREATE VIEW command.

  3. Oracle views can be queried.

  4. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL-92 standard explicitly prohibits ORDER BY in view definitions because views represent unordered sets. However, Oracle extends this by allowing ORDER BY in conjunction with top-N queries or specific restrictions. Option A correctly states that Oracle views cannot use ORDER BY in standard view definitions without special syntax.

Keep practicing — related questions