SOLVED: Which of the following statement is true about temporary table?

Which of the following statement is true about temporary table?

Local temporary table should be prefixed with ‘##

Global temporary table is stored in master database

Local temporary table is created be default

Temporary tables (local or global) are stored in tempdb database

Verified Answer

Correct Option - d

To get all Infosys Certified MS SQL Server Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee