Section 1: Views

Section 1: Views

1. Review Questions

1. What is a View in PostgreSQL?
2. Why do we use Views?
3. Can a View be created using multiple tables?
4. What is the purpose of CREATE OR REPLACE VIEW?
5. How can we rename a View?
6. How can we delete a View?
7. Does deleting a View delete the original table?
8. What is the difference between a normal View and a table?
9. Can we update data through every view?

Section 2: Materialized Views

1. What is a Materialized View in PostgreSQL?
2. What is the main difference between a View and a Materialized View?
3. Does a Materialized View automatically update when source table data changes?
4. Which command refreshes a Materialized View?
5. What is the purpose of WITH NO DATA?
6. What is the purpose of REFRESH MATERIALIZED VIEW CONCURRENTLY?
7. How can we list all Materialized Views in PostgreSQL?