What is the difference between a Local and a Global temporary table?

Correct Answer: Local : Only available to the current Db connection for current user and are cleared when connection is closed Multiple users can’t share a local temporary table Global: Available to any connection once created They are cleared when the last connection is closed Can be shared by multiple user sessions