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.
What is meant by the Drill Through?
Illustrates the term tkprof and how is this used?
State functionality of the repository manager?
Explain the types of jobs we have within the Data stage?
Explain the term version Control?
Give a brief introduction of the term real time data-warehousing?
Illustrates the various extensions for stored procedures?
Explain the term replication server software?
Explain the loops?
Define the Linked List in data structure?
18,76,764
1952007 Asked
3,689
Active Tutors
1434836
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!