Which of the following statements is not true for views in SQL?
2013
Which of the following statements is not true for views in SQL?
- A.
Select statement used in the view definition cannot include ORDER BY clause.
- B.
A view derives its data from the base table(s).
- C.
A view is updatable if it has been defined from a single relation.
- D.
A view contains a copy of the data.
Attempted by 86 students.
Show answer & explanation
Correct answer: D
Answer: The statement "A view contains a copy of the data." is not true for standard (non-materialized) views. Select statement used in the view definition cannot include ORDER BY clause. — Generally true for standard SQL: views represent unordered result sets, so ORDER BY is not allowed in view definitions except in certain DBMS-specific cases (for example when combined with TOP/LIMIT) or in materialized views. To enforce ordering, use ORDER BY when querying the view.
A video solution is available for this question — log in and enroll to watch it.