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 the term data warehouse?
Write a short note on the difference between embedded and dynamic SQL?
Explain the usage of the repository connectivity?
Write down the some of the important security characteristics of a DBMS?
Explain the term Business Objects Repository?
Explain the working of the IPC Stage?
What are the kinds of files employed in Oracle recovery?
Explain in brief the term apex cuboids.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
To perform recursion which data structures is used?
18,76,764
1950353 Asked
3,689
Active Tutors
1426352
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!