Illustrate different types of locks in sql server, Database Management System

Assignment Help:

Illustrate different types of Locks in SQL Server.

There are three kinds of locks in SQL Server

i.) Shared locks - These are used for operations which don't allow any update or change of data. For example SELECT.

ii.) Update locks - These are used when SQL Server wants to modify a page. Update page lock is then promoted to an exclusive page lock before actually making changes.

iii.) Exclusive locks - they are used for data modification operations. For example UPDATE, INSERT, or DELETE.

Related Discussions:- Illustrate different types of locks in sql server

Explain disadvantages of a dbms, Question : (a) Database Management Sy...

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

Explain the concept of data mining, Question 1 Explain the concept of Fore...

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

What is a security, What is a security? Securities are claims on financ...

What is a security? Securities are claims on financial assets. They can be illustrated as "claim checks" which give their owners the right to receive funds in the future. Sec

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Define and differentiate among ordered indexing and hashing, Define and dif...

Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every

Lock, intent locking

intent locking

Set concept is used in which type of modelling, SET concept is used in whic...

SET concept is used in which type of modelling? SET concept is used in Network Model.

I need help on the following 5 questions, 1. Define and discuss Work Breakd...

1. Define and discuss Work Breakdown Structure, Critical Path Analysis, PERT charts and GANTT charts. Describe the role of each in determining scope, budgets, and schedules? What

Example of equijoin, Example: Consider the following relations: ...

Example: Consider the following relations: ROLLNO NAME ADDRESS COURSE_ID 100 Ka

What are the two integrity rules, What are the two integrity rules? An...

What are the two integrity rules? Ans: The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule. Entity Integrity Rule - If the attribute A of rel

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages