Questions

1. Briefly describe the differences between a view, an updatable view, and a materialized view.
2. List the index types supported by PostgreSQL.
3. For range operators, such as > and <, which index type can be used?
4. For the equality operator (=), which index type can be used?
5. Which programming languages can be used to implement user-defined functions in PostgreSQL? Which languages are supported out of the box?
6. What are function volatility classifications?
7. What are the advantages of using trigger systems overrule systems in PostgreSQL?
8. Suppose that a developer would like to write a function to perform sanity checks for data. Which trigger event is suitable for this task?
9. Create a domain for positive integers.
10. How can ENUM be used to reduce the number of joins when writing SQL code?