The Update Anomaly in Non-Normalized Database Tables

question 32

Multiple Choice

The update anomaly in non-normalized database tables

• A)occurs because of data redundancy.
• B)restricts addition of new fields or attributes.
• C)results in records that cannot be updated.
• D)is usually easily detected by users.

---

Definitions:

Actual Rate

The real interest rate or exchange rate that is applied in current transactions, distinct from theoretical or future rates.

Standard Rate

A predetermined cost or price used in budgeting and costing exercises, reflecting an expected or agreed level of expenditure or charge.

Variable Factory Overhead Controllable Variance

The difference between the actual and budgeted variable overhead costs that management has the ability to influence or control.

Actual Hours

The real number of hours worked or spent on a particular activity or project, as opposed to planned or estimated hours.