The database administrator (DBA) suggests that DB efficiency can be improved by denormalizing
some tables. This would result in:

A.
loss of confidentiality.

B.
increased redundancy.

C.
unauthorized accesses.

D.
application malfunctions.

Explanation:

Normalization is a design or optimization process for a relational database (DB) that minimizes
redundancy; therefore, denormalization would increase redundancy. Redundancy which is usually
considered positive when it is a question of resource availability is negative in a database
environment, since it demands additional and otherwise unnecessary data handling efforts.
Denormalization is sometimes advisable for functional reasons. It should not cause loss of
confidentiality, unauthorized accesses or application malfunctions.