SOLVED: Which of the following statements are TRUE with respect to temporary tables? CHO ...

Which of the following statements are TRUE with respect to temporary tables? CHOOSE TWO CORRECT OPTIONS.

Global Temporary tables can be shared between concurrent connections

Transactions in tempdb are logged and hence data in temporary tables can be rolled back

By default both private and global temporary tables will be created in master database

Private temporary tables can be accessed across multiple sessions of same user

Verified Answer

Correct Option - ab

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