Answer – Objective Question (In which database temporary tables are created in SQL Server)

Posted on January 11, 2014 by vivekjohari
Question :- In which database temporary tables are created in SQL Server?

1) User database (where temporary table are defined)
   
2) Master database
   
3) TempDB (Correct Answer)

4) Model Database

5) None of the above

Answer
 Thanks to all who attempted this question. 84% people gives the correct answer:-)

Correct answer is option 3, TempDB. All the temporary tables and table variables are created in the TempDB.

Related Articles

SQL Server – Local temporary table

SQL Server – Global temporary tables

DMCA.com

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in Interview Questions and tagged . Bookmark the permalink.

31 Responses to Answer – Objective Question (In which database temporary tables are created in SQL Server)

  1. venu Goud says:
    March 25, 2014 at 2:40 pm

    Hi Vivek

    same type of Question raised on of my Guy!
    Where it is located Resourece Database?

    Reply

  2. Pingback: anchor

  3. Pingback: Gas Line Services in ann arbor

  4. Pingback: คาสิโนออนไลน์ที่ดีที่สุด

  5. Pingback: central qq

  6. Pingback: 배트맨토토

  7. Pingback: w88

  8. Pingback: custom instrument cases

  9. Pingback: didi

  10. Pingback: https://pavingcontractorscrew.info/usa/paving-contractors/hi

  11. Pingback: novushub write an article

  12. Pingback: w88th

  13. Pingback: แชมเปี้ยนชิพ

  14. Pingback: vao fun88

  15. Pingback: data sgp

  16. Pingback: https://biznesblog.biz.pl/forum/marketing-f5/opinie-o-funkymedia-t64.html

  17. Pingback: https://internetnews.net.pl/echo-serca-plodu-zalecane-przeprowadzenie-badania-czym-polega/

  18. Pingback: cbd

  19. Pingback: i99bet

  20. Pingback: Dream Market

  21. Pingback: Samsara Market

  22. Pingback: m88a

  23. Pingback: ca do

  24. Pingback: Cryptonia Market

  25. Pingback: Apollon Market Exit Scam

  26. Pingback: Namibia Road, Rail, Air Freight Market 2020 Industry Trends, Production, Sales, Supply, Demand, Analysis & Forecast to 2026

  27. Pingback: 2025 Projections: Safety Data Sheet (SDS) Market Report by Type, Application and Regional Outlook

  28. Pingback: m88

  29. Pingback: https://novushub.com/hindi-gana-video/

  30. Pingback: uniccshop

  31. Pingback: ซีเกมส์ 2019

Leave a Reply