Which are more commonly used: implicit or explicit locks? Why?
What will be an ideal response?
Implicit locks are more commonly used than explicit locks. Concurrency control involves many complex factors that influence the performance of the system. The impact of some of these factors can only be determined through trial and error. Changing explicit locks to tune system performance can require making changes throughout the program code to obtain and release locks at various places in the transactions. Implicit locks are much easier to change since a locking strategy can be specified in a system parameter or lock declaration area and then the DBMS will place the locks implicitly wherever they are needed to implement that strategy.
You might also like to view...
The Likert scale is also referred to as a summated scale
Indicate whether the statement is true or false
The overall project risk factor is known to be 0.5. The probability of dependency failure is twice the probability of complexity failure and four times the probability of maturity failure
The consequence of performance failure is twice the consequence of reliability failure, four times the consequence of schedule failure and eight times the consequence of cost failure. What is the difference between the probability of maturity failure and the consequence of cost failure? Maturity X Cost Y Complexity 2X Schedule 2Y Dependency 4X Reliability 4Y Performance 8Y A) 0.026 B) 0.033 C) 0.041 D) 0.048