Database Fundamentals — Question 127

Which keyword must be included in a create view statement?

Answer options

• A. WHERE
• B. ORDER BY
• C. UPDATE
• D. SELECT

Correct answer: D

Explanation

The correct answer is D, as a CREATE VIEW statement requires a SELECT statement to define the data the view will present. The other options, while relevant to SQL, do not apply to the creation of views; WHERE is used for filtering, ORDER BY for sorting, and UPDATE for modifying data.