NEW
Font size
WorksheetsData Manipulation
Total questions: 9
Worksheet time: 3mins
What is the main data issue?
Physical data damage
Human data entry error
Network failure
Hardware failure
Why did the system calculate incorrect scores?
Wrong formula
Missing validation for empty values
Database corruption
Power failure
What caused the delivery failure?
Server crash
Incorrect lookup table
No format or lookup validation
Poor internet connection
Which validation would help prevent the blood type error?
Range check
Lookup validation (blood group list)
Length check
Check digit
What is the best validation rule to prevent blank scores?
Presence check
Format check
Lookup check
Check digit
Best validation to reduce address errors?
Range check
Lookup / dropdown list
Length check
Check digit
A hospital database records a patient’s blood type as AB instead of O due to a data entry error.
The patient urgently needs a blood transfusion.
Logical integrity
Physical integrity
A spreadsheet allows students’ exam score cells to be left blank.
The system treats blank cells as 0, causing incorrect final results.
Logical integrity
Physical integrity
An online shopping system allows free-text address input with no validation.
A customer types “Jl. Meredeka” instead of “Jl. Merdeka”.
Logical integrity
Physical integrity
