ITPEC FE Morning April 2018 Question 24

Source exam: ITPEC FE Morning April 2018Topic: Databases

ITPEC FE Morning April 2018 — Question 24 of 80

Logical check (input validation) — verify that Order date is a business day ≤ entering date.

A logical check validates that data makes sense according to business rules, not just format.

Examples of each check type:
- Format check — is the date in YYYY-MM-DD format? Are digits where expected?

- Duplication check — does this form number already exist?

- Sequence check — are form numbers in ascending order?

- Logical check — is the date a real business day? Is it not in the future?

Why (d):
- "Order date is on a business day" → business rule validation

- "Equal to or prior to entering date" → cross-field logic (date ≤ today)

- Both are logical validity checks, not format or sequence

Why not others:
- (a) Sequence check — checks ordering of records, not date validity

- (b) Duplication check — checks for duplicate entries

- (c) Format check — checks data type/pattern, not whether the value is logically valid

AI-generated — may contain errors

The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.

This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.