Database Fundamentals — Question 81

You need to create a view to filter rows of data from an underling table.
Which type of clause must be included in the CREATE VIEW statement?

Answer options

• A. CONSTRAINT
• B. WHERE
• C. JOIN
• D. FILTER

Correct answer: B

Explanation

The correct answer is B, WHERE, because it is the clause used to specify conditions that filter the rows returned by the view. Options A (CONSTRAINT), C (JOIN), and D (FILTER) do not pertain to the creation of a view in SQL for filtering data.