Sqlserver Interview questions

Total available count: 45
Subject - Databases
Subsubject - Sqlserver

Explain different types of Locks in SQL Server?

There are 3 kinds of locks in SQL Server,
1. Shared locks:  They are used for operations which do not allow any change or update of data. For example, SELECT.
2. Update locks: They are used when SQL Server wants to modify a page. The update page lock is then promoted to an exclusive page lock before actually making the changes.
3. Exclusive locks:  They are used for the data modification operations. For example, UPDATE, INSERT, or DELETE.

Next 5 interview question(s)

What is SQL Server Agent?
What is SQL Profiler?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is OLTP (Online Transaction Processing)?
What are different types of Collation Sensitivity?