ITPEC FE Morning April 2022 Question 23

Logical Check (Input Validation) — verify that the order date is on or before the entering date.

The question asks which check ensures the order date does not exceed the entering date — a cross-field business rule.

• •Logical check — validates that data values make sense in context (e.g., order_date ≤ entering_date, start < end, quantity > 0)
• •Duplication check — detects repeated records (e.g., same form number entered twice)
• •Format check — ensures correct data format (e.g., date as YYYY-MM-DD, no letters in numeric fields)
• •Sequence check — verifies records arrive in expected order (e.g., form numbers 001 → 002 → 003)

Why not others:
- (a) Duplication check — checks for duplicate entries, not date relationships
- (b) Format check — checks character/type patterns, not value logic
- (d) Sequence check — checks ordering of record identifiers, not field-to-field comparison

Key rule: When two fields are compared for business-rule validity (date ranges, thresholds, cross-field constraints), the answer is always logical check.

AI-generated — may contain errors