Quiz for Updateable vs Non-Updateable Views

Q1: Which of the following is generally TRUE about updateable views?

A. They must reference multiple tables B. They cannot have WHERE clause C. They must include a primary key D. They cannot contain GROUP BY or JOIN

Q2: Which of the following statements about updateable views is true?

A. They always support INSERT operations B. They support UPDATE only if certain conditions are met C. All views are updateable by default D. None of the above

Q3: Which SQL feature determines if a view can be updated?

A. Triggers B. View Definition C. Table Constraints D. Index Type

Q4: A view created with a GROUP BY clause is:

A. Updateable B. Non-updateable C. Partially updateable D. Always updateable if indexed

Q5: Can a view with JOINs be updated?

A. Yes, always B. Yes, if only one table is involved C. No, never D. Only if it has a primary key

Q6: Which clause can prevent a view from being updated?

A. WHERE B. ORDER BY C. DISTINCT D. HAVING

Q7: Why are views with aggregate functions non-updateable?

A. They contain duplicated data B. They lack primary keys C. Aggregate values don’t map to base rows D. They are optimized differently

Q8: Which of the following makes a view non-updateable?

A. Referencing one base table B. Having a WHERE clause C. Using UNION D. Using WHERE and ORDER BY together

Q9: Can a view that selects from a read-only table be updated?

A. Yes B. No C. Only if indexed D. Only by superuser

Q10: A view with subqueries in the SELECT clause is usually:

A. Updateable B. Non-updateable C. Depends on DBMS D. Partially updateable

Q11: How can we make a non-updateable view updateable?

A. By removing DISTINCT and joins B. By creating an index C. By renaming columns D. By using ORDER BY

Q12: What does the WITH CHECK OPTION do for updateable views?

A. Disables insert B. Allows joins C. Ensures data satisfies view condition on insert/update D. Adds WHERE clause to insert statements

Q13: Which of the following is true about non-updateable views?

A. They cannot be queried B. They cannot be created C. They cannot be modified directly D. They can always be indexed

Q14: Can a view based on multiple tables be updateable?

A. Yes, if only one table is updated B. No C. Only if it’s a materialized view D. Only in Oracle DB

Q15: When is a view considered simple and updateable?

A. When it contains GROUP BY B. When it selects from one table without complex clauses C. When it has ORDER BY D. When it includes DISTINCT

Q16: Can a view containing only column aliases be updateable?

A. Yes B. No C. Only if no WHERE clause exists D. Depends on the DBMS

Q17: A view defined with TOP or LIMIT clause is usually:

A. Always updateable B. Never updateable C. Updateable in Oracle D. Updateable with trigger

Q18: Materialized views are:

A. Always updateable B. Never updateable C. Sometimes updateable D. Updateable only when indexed

Q19: Which SQL command defines a view?

A. CREATE VIEW B. MAKE VIEW C. ALTER TABLE D. INSERT VIEW

Q20: If a view has a computed column, is it updateable?

A. Yes B. No C. Only in SQL Server D. Only if joined

Q21: Can triggers make non-updateable views behave like updateable ones?

A. Yes, by routing changes to base tables B. No C. Only INSERTs work D. Only DELETEs work