ITPEC FE Morning October 2023 Question 23
When an order data in the format shown below is entered, which of the following is a data validation method that is performed to determine whether the order date is a business day and whether the date is on or before the date of data entry or after the date of data entry?
Order data
Explanation
Logical check — it tests whether a value makes sense against a rule or other data, here whether the order date is a business day and how it compares with the entry date.
A date can be perfectly formed, the right number and kind of characters, and still fall on a holiday or after the day it was entered. Comparing it with a calendar of business days and with the entry date checks its plausibility, not its shape. Checks for consistency with business rules, other fields or reality are logical checks.
Answer (c)
Why not others:
- •(a) Duplicate check — detects the same data entered twice, such as a repeated slip number
- •(b) Format check — verifies the form of the value, such as the date having the right characters, not whether the date is plausible
- •(d) Sequence check — verifies that records or keys arrive in the expected order, such as ascending slip 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 duplicate 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.