SQL

1. Difference between creating persistent objects vs. creating temporary objects. Include situations that are better suited for persistent objects, and situations that are better suited for temporary objects.

2. Difference between local temporary tables and global temporary tables. How is the scope of each type different. When would it be better to use global vs. local? When would it be better to use local vs. global?