Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SQL > Data Integrity > Flashcards

Data Integrity 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 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions