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 .