SQL Server Temporary Tables Interview Questions and Answers
Q.1 What are Temporary tables?
Q.2 What are the 2 types of Temporary Tables in SQL Server?
Q.3 What is a Local Temporary Table?
Q.4 What are Global Temporary Tables in SQL Server?
Q.5 What are the differences between Local and Global Temporary Tables?
Q.6 Can you please explain when to use a temp table in SQL Server?
Q.7 Can you create foreign key constraints on temporary tables?
Q.8 Do you have to manually delete temporary tables?
Q.9 In which database, the temporary tables get created?
Q.10 How can I check for the existence of a temporary table?
Q.11 SQL appends random function as at the end of the Local table’s name. So, we can create a Local table with the same name. But the Global table’s name has to be unique. Why is that?
Q.12 How to copy the structure of the temporary table from one table to another? i.e., copying the only structure and no data?
Q.13 What is the difference between a Temporary Table and a Table variable?
No comments:
Post a Comment