SQL Server Interview Questions Part 1

1. What is Junction table in SQL Server?
2. What is difference between Varchar(max) and Varchar?
3. What is Check constraint?
4. Is NVarchar takes double space in memory?
5. How to insert data into a table with just one IDENTITY column?
6. Difference between @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT?
7. Difference between Table Variable,Local Temp,Global temporary tables,Tempdb permanent tables?
8. Difference between CTE Vs Local Temp Table?
9. What is the basic functions of master, msdb, model, tempdb databases?
10. SELECT CONVERT(INT,NULL)?
11. Difference between Index Seek Vs Index Scan?
12. What is ACID property of database?
13. What are CODD’s 12 rules?
14. What are table hints in SQL Server?
15. What is the default port number for SQL Server?
16. What are magic tables in SQL Server?
17. Difference between Implict Transaction And Explict Transaction?
18. What is dirty Read in SQL Server?
19. What is repeatable read in SQL Server?
20. What is Synonym in SQL Server?