SQL Database Concepts Question: Download Questions PDF
Tell me what is the difference between Locking and multi-versioning?
Answer:
Locking is a means of not allowing any other transaction to take place when one is already in progress. In this the data is locked and there won’t be any modification taking place till the transaction either gets successful or it fails. The lock has to be put up before the processing of the data whereas
Multi-versioning is an alternate to locking to control the concurrency. It provides easy way to view and modify the data. It allows two users to view and read the data till the transaction is in progress.
Multi-versioning is an alternate to locking to control the concurrency. It provides easy way to view and modify the data. It allows two users to view and read the data till the transaction is in progress.
Download Basic SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
Do you know what are ACID properties? | Tell me what is normalization? Explain different forms of normalization? |