Interview Questions -- SQL Server -- Part-2

                      Following are the some of the SQL Server basic interview questions.

Questions:-

• What is JOINs and its types.
• What is Inner join and any real time example please.
• What is the scope of local Temp Tables and Global Temp tables.
• What is the use of RANK() function.
• Difference between RANK() and DENSERANK().
• Have you used ROW_NUMBER() function any time.
• What is System Defined Function OR Built-In Functions.
• Can You list out what are the Built-In Functions available.
• What is CASE Statements and how it is different from If else Statement.
• What is Correlated Subquery and have you used any time.
• Difference between DATEPART() and DATENAME() Functions.
• Difference between IS NULL and ISNULL() function.
• What is STUFF() function.
• What is the SQL Server version you are using in production.
• What is SQL Server Default TCP/IP Port Number
• Have you ever used UPDATE_STATISTICS Command
• Difference between Primary Key and Unique Key
• What ACID Property in Database
• what do you mean by SEED in Identity Column.

Please share your answer through comments.