Which of the following refers to the correctness and completeness of data in a database?

The correct answer is C. Data integrity. Data integrity (C) refers to the accuracy, correctness, and completeness of data stored in a database - ensuring data remains valid and consistent throughout its lifecycle, whether during entry, storage, or retrieval. A (Data security) is wrong because security deals with…

Database Fundamentals

Question

Options

AData security
BData independence
CData integrity
DData constraint

How the community answered

(49 responses)

A
6% (3)
B
4% (2)
C
88% (43)
D
2% (1)

Explanation

Data integrity (C) refers to the accuracy, correctness, and completeness of data stored in a database - ensuring data remains valid and consistent throughout its lifecycle, whether during entry, storage, or retrieval.

A (Data security) is wrong because security deals with protecting data from unauthorized access, not its accuracy.
B (Data independence) is wrong because that describes the ability to change data structure without affecting application logic.
D (Data constraint) is wrong because constraints are mechanisms used to enforce integrity (like NOT NULL or UNIQUE rules), not the concept of correctness itself.

Memory tip: Think of "integrity" as meaning "honest and complete" - just like a person of integrity tells the truth, data integrity means the data tells the truth about reality.

Topics

#Data integrity#Database fundamentals#Data quality#ACID properties

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice