Differences between CHAR, NCHAR, VARCHAR and NVARCHAR?

What is Constraint? And types of constraints in SQL Server?

Difference between Primary Key and Unique Key?

What are joins? And types of joins in SQL Server?

Difference between Inner Join and Join in SQL Server

What is Equi Join in SQL Server?

What is Non Equi Join in SQL Server?

Difference between Left Join and Left Outer Join in SQL Server?

Difference between Right Join and Right Outer Join in SQL Server?

Difference between Full Join and Full Outer Join in SQL Server?

What is Cross Join in SQL Server?

What is Batch and types of Batches in SQL Server?

Difference between Stored Procedure and Function?

Types of functions in SQL Server

What is Trigger in SQL Server?

How many types of triggers are there?

What is Cursor in SQL Server?

Explain the Cursor types?

Explain different types of cursors?

Define the Cursor lock types?

What are the disadvantages of cursors?