ITPEC FE Morning October 2023 Question 23

Logical Check (Data Validation) — verify that data values make business sense.

The question asks which validation method checks whether the order date is a business day and whether it is on or before the data entry date.

• •Logical check — verifies that data is meaningful and reasonable, not just correctly formatted
• •Example: "Is the date a business day?", "Is the date not in the future?", "Is quantity positive?"

Why not others:
- (a) Duplicate check — detects repeated entries (e.g., same Slip No. entered twice)
- (b) Format check — validates data type/pattern (e.g., date matches YYYY-MM-DD, number field contains only digits)
- (d) Sequence check — ensures records are in expected order (e.g., Slip No. increments: 001 → 002 → 003)

Key rule: If the check asks "does this value make sense in context?" → Logical check. If it asks "is the format correct?" → Format check.

AI-generated — may contain errors