A database administrator has detected a performance problem with some tables which could be solved through denormalization. This situation will increase the risk of:

A.
concurrent access.

B.
deadlocks.

C.
unauthorized access to data.

D.
a loss of data integrity.

Explanation:
Normalization is the removal of redundant data elements from the database structure. Disabling normalization in relational databases will create redundancy and a risk of not maintaining consistency of data, with the consequent loss of data integrity. Deadlocks are not caused by denormalization . Access to data is controlled by defining user rights to information, and is not affected by denormalization .