Materialized View orTemporary Tables in SQL
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is a temporary table in SQL?
2. What happens to a temporary table when the database session ends?
3. Which two characteristics distinguish temporary tables?
4. What kind of data are temporary tables designed to store?
5. How does a materialised view differ from a temporary table in terms of persistence?
6. How can a materialised view be refreshed?
7. For which type of workload do materialised views significantly improve performance?
8. In a data warehousing project, how are materialised views and temporary tables typically divided?
9. In a web application, which construct would store frequently accessed data such as top-rated products?
10. Which statement about temporary tables is NOT correct?