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)

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