ITPEC FE Subject A April 2025 Question 17
When ordering data is entered in the format shown below, which of the following is the appropriate method for checking whether the order date is a business day that is the same as or prior to the entering date?
Ordering data
Explanation
Logical check — it tests whether a value makes sense against a rule or another value, here that the order date is a business day no later than the entering date.
Comparing the order date with the entering date and with a calendar of business days goes beyond the shape of the field: a date can be perfectly formatted and still fall on a holiday or after today. Checks for consistency with business rules, other fields or reality are logical checks.
Answer (c)
Why not others:
- •(a) Duplication check — detects the same data entered twice, for example a repeated form number
- •(b) Format check — verifies the form of the value, such as a date having the right number and kind of characters, not whether the date is plausible
- •(d) Sequence check — verifies that records or keys come in the expected order, such as ascending form numbers
Key rule: Format check asks whether a value looks right, logical check whether it makes sense, sequence check whether it is in order, and duplication check whether it is unique.
Human Interface · AI-written, may contain errors
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.