ITPEC FE Morning April 2018 Question 24
When ordering data in the format below is entered, which of the following is an appropriate check to examine whether the value of the Order date field is on a business day equal to 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 the day it was entered. Checks for consistency with business rules, other fields or reality are logical checks.
Answer (d)
Why not others:
- •(a) Sequence check — verifies that records or keys come in the expected order, such as ascending form numbers
- •(b) Duplication check — detects the same data entered twice, for example a repeated form number
- •(c) 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
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.