Pessimistic locking and optimistic locking
Describe briefly the difference between pessimistic locking and optimistic locking?
Expert
Optimistic locking supposes no transaction conflict will happen and deals with the consequences when it does. Pessimistic locking supposes that conflict will happen and so prevents it ahead of time with locks. Basically, optimistic locking is preferred for the Internet and for many intranet applications.
Specify the designer tools used for creating the tranformations?
What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?
When the collision and overlapping take place at same time, what will be the bucket size?
Describe the main characteristic of the database administrator?
Briefly describe the differentiation between data warehousing and data mining ?
Specify the several Business Objects products?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Write about fossils?
What do you mean by the term Open Server in the Sybase?
Describe briefly Aggregate transformation?
18,76,764
1926747 Asked
3,689
Active Tutors
1435644
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!