Question: What is the advantage of using a temporary table instead of a heap table?

  1. The temporary table will be dropped when the database is restarted.
  2. Temporary tables can be shared among clients, which makes them more usable in group development environments.
  3. The temporary table will be dropped as soon as your session disconnects.
  4. 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.