SQL > Data Integrity > Flashcards

Data Integrity Flashcards

(4 cards)

Study These Flashcards
1
Q

Entity Integrity

A

This ensures that there are no duplicate rows in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Domain Integrity

A

Enforces valid entries for a given column by restricting the type, the format, or the range of values.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Referential integrity

A

Rows cannot be deleted, which are used by other records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

User-Defined Integrity

A

Enforces some specific business rules that do not fall into entity, domain or referential integrity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
SQL
flashcards
Decks in class (4)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions