What difference between temporary table and global temporary table?

Question

Accepted Answer

Temporary tables are session-specific while global temporary tables are accessible across sessions.

Temporary tables are created in a user's temporary tablespace and are automatically dropped at the end of the session.
Global temporary tables are created in a user's temporary tablespace but are not automatically dropped at the end of the session.
Temporary tables are only accessible within the session that created them.
Global temporary tables can be accessed by multiple sessions.
Temporary tables have a name that starts with 'ORA$TEMP$'.
Global temporary tables have a name that starts with 'ORA$GLB$'.

Top Soho House Mumbai Senior ETL Developer interview questions & answers