Concurrency control in DBMS
What do you understand by the term concurrency control in DBMS?
Expert
Concurrency control is the procedure of managing concurrent operations against a database so that database integrity is not adjusted. There are two approaches to concurrency control.
Pessimistic approach: consists of locking Optimistic approach: consists of versioning.
Explain how is the HASH file used and where we can use it?
Illustrates the term data sparsity and how this effect upon aggregation?
Describe the term Derivations, Stage Variables and Constants?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
How can we do unit testing into the informatica? How to load data in the informatica?
Can we stop and start one session in the concurrent batch?
Explain the term replication server software?
Illustrates the benefits of running stored procedure upon a database engine?
Give brief introduction of the term broad cast agent?
Describe the some drawbacks of a standard language like SQL?
18,76,764
1935785 Asked
3,689
Active Tutors
1432177
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!