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.
Describe briefly Recovering sessions?
Give a brief introduction of the term real time data-warehousing?
Write out the disadvantages of using the Alias?
Explain the operations that can be done with the Data Stage Director?
Contrast a fat and a thin client?
Describe how operation is carried out within the spiral method?
Write about fossils?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Differentiate between start schma and Fsldm?
Name the methods that are available in storing sequential files?
18,76,764
1948694 Asked
3,689
Active Tutors
1424985
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!