Quiz for Views

Q1: What is a view in SQL?

A. A backup file B. A real table C. A virtual table D. A log file

Q2: Can a view be based on multiple tables?

A. Yes B. No C. Only on one table D. Only on indexed tables

Q3: Which SQL keyword is used to create a view?

A. MAKE VIEW B. GENERATE VIEW C. CREATE VIEW D. SET VIEW

Q4: Can you insert data into a view?

A. Yes, always B. No C. Sometimes, depending on the view D. Only if it has a primary key

Q5: Which of the following is true about views?

A. They store data B. They are stored procedures C. They simplify complex queries D. They are always updateable

Q6: How can you remove a view in SQL?

A. DELETE VIEW view_name B. REMOVE VIEW view_name C. DROP VIEW view_name D. CLEAR VIEW view_name

Q7: What does the WITH CHECK OPTION do in a view?

A. Prevents deletion B. Ensures view-based inserts follow conditions C. Adds encryption D. Logs queries

Q8: Can views have parameters?

A. Yes B. No C. Only in stored procedures D. Only in MySQL

Q9: What happens when the underlying table of a view is dropped?

A. View still works B. View auto-converts to a table C. View becomes invalid D. View stores the last data

Q10: What is the purpose of using views?

A. To backup data B. To increase performance always C. To simplify access to data D. To replace tables

Q11: Which clause is used to update an existing view?

A. MODIFY VIEW B. ALTER VIEW C. CHANGE VIEW D. UPDATE VIEW

Q12: Can you create an index on a view?

A. Yes, always B. No, never C. Only if it is a materialized view D. Only if it is indexed already

Q13: Which of the following is NOT a benefit of using views?

A. Security B. Simplification C. Faster access always D. Hiding data complexity

Q14: How do views help with data security?

A. By encrypting data B. By blocking DELETE operations C. By restricting columns/rows exposed D. By making tables invisible

Q15: Can a view be indexed in MySQL?

A. Yes, regular views are indexed B. No, views are never indexed C. Only materialized views can be indexed D. Only with triggers

Q16: Which command is used to see the definition of a view?

A. SHOW VIEW B. DESCRIBE VIEW C. SHOW CREATE VIEW D. SELECT VIEW

Q17: Can you join a view with a table?

A. No B. Yes C. Only if view has index D. Only if table has key

Q18: Which of the following views can you insert into?

A. View with JOIN B. View with GROUP BY C. Simple view without aggregation D. View with HAVING clause

Q19: What is a materialized view?

A. A live view B. A view that stores result set physically C. A stored procedure D. A fast temporary table

Q20: Which clause allows modifying data through a view safely?

A. WITH FORCE B. WITH UPDATE C. WITH CHECK OPTION D. ALLOW MODIFY