Data Validation Flashcards

all about data validation

You may prefer our related Brainscape-certified flashcards:
1
Q

What is data validation

A

Data validation is the process of ensuring that data entered into a system meets certain criteria for accuracy, completeness, and consistency

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

Range check

A

Ensures that values fall within a specified range

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

Type check

A

Ensures that data is of the correct type, such as alphabetic or numeric

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

Presence check

A

Prevents essential fields from being blank

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

Uniqueness check

A

Ensures that there is no duplication or overlap

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

Check digit

A

Ensures that code numbers that are originally produced by a computer are re-entered into another computer correctly.

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

Length check

A

Confirms that a data entry has the correct length.

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

Consistency check

A

Filters out bad data to ensure high-quality data for proper analysis.

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

difference between data validation and data verification

A

data validation ensures that data meets predefined criteria for quality and consistency, while data verification confirms the accuracy and correctness of the entered data through various methods.

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