ITPEC FE Morning October 2019 Question 25

Logical Check (Data Validation) — identify the type of validation that checks whether a date value is logically valid.

The question asks which validation checks that the order date is on or before the business day of data entry.

• •Logical check — verifies that data values make sense in relation to each other (e.g., order date ≤ entry date)
• •Duplicate check — detects repeated records (e.g., same Slip No. entered twice)
• •Format check — ensures data matches the expected format (e.g., Quantity must be numeric)
• •Sequence check — verifies records are in the correct order (e.g., Slip No. ascending)

Why not others:
- (a) Duplicate check — no repeated records are being compared
- (b) Format check — the issue is not about data type or pattern
- (d) Sequence check — no ordering of records is involved

Key rule: When a validation compares two values to check if the relationship between them is reasonable, it is a logical check.

AI-generated — may contain errors