. What are the type of locks ?

Answer

1. Shared Lock
When a shared lock is applied on data item, other transactions can only read the item, but can't write into it.

2. Exclusive Lock
When an exclusive lock is applied on data item, other transactions can't read or write into the data item.

All sql dba Questions

Ask your interview questions on sql-dba

Write Your comment or Questions if you want the answers on sql-dba from sql-dba Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---