We have obtained access to the company's operational data. In one ...

[daltonest1984]

We have obtained access to the company's operational data. In one record, we find that a customer's age has been recorded as 337. This is an example of ________.
 
  A) dirty data
  B) inconsistent data
  C) non-integrated data
  D) a wrong format problem

Question 2

Which are more commonly used: implicit or explicit locks? Why?
 
  What will be an ideal response?

[Eunice618]

Answer to Question 1

A

Answer to Question 2

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.