Explain unique key in sql server?
What is the basic difference between clustered and a non-clustered index?
Can we do dml on views?
How to get nth highest salary from employee table.
What is difference between commit and rollback when used in transactions?
Explain Normalization and DE normalization
How to search for a string in all stored procedure in sql server?
How many joins in sql server?
Define outer join?
What is a NOLOCK?
How to use linked server?
Explain “row_number()” in sql server with an example?
How many types of cursor type are there?