KwickClips Databases and SQL · 41 sec · free
What is the difference between validation and verification?
Short answer. Validation checks sensible data; verification checks it was entered correctly.
Which check stops an empty field?
The presence check.
Validation checks
| Check | Example |
|---|---|
| Range | Price 1-5000 |
| Length | BookID 3 chars |
| Presence | Title filled |
Remember
| Sensible, not correct |
| Verification is different |
Does validation prove data is correct? Three common checks. Range keeps a value within limits. Length counts characters. Presence stops empty fields. Two points. Validation means sensible, not correct. Verification differs.
This clip is from the full lesson: SQL for Cambridge IGCSE: Single-table Databases and Queries — 8 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 9 Computer Science (0478), Cambridge IGCSE Grade 10 Computer Science (0478)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.