Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

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

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

Comments

Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...