Question: What is the advantage of using a temporary table instead of a heap table?
- The temporary table will be dropped when the database is restarted.
- Temporary tables can be shared among clients, which makes them more usable in group development environments.
- The temporary table will be dropped as soon as your session disconnects.
- Creating a temporary table does not require any special privileges.
Answer: The correct answer of the above question is Option C:The temporary table will be dropped as soon as your session disconnects.