Question 1: Views in RDBMS - Definition
What is a view in a relational database?
Question 2: View Creation - Syntax
Which SQL command is used to create a view?
Question 3: View Usage - Querying
How can you retrieve data from a view?
Question 4: Updatable Views - Condition
Which type of view allows INSERT, UPDATE, or DELETE operations?
Question 5: Advantages of Views
What is an advantage of using a view?
Question 6: View with Joins
Can a view be created from multiple tables using JOINs?
Question 7: View and Security
How do views improve database security?
Question 8: Dropping a View
Which command is used to delete a view?
Question 9: View vs Table
Which statement is true about views compared to tables?
Question 10: Materialized View
How does a materialized view differ from a normal view?