ITPEC FE Morning April 2022 Question 23

When ordering data is entered in the format shown below, which of the following is appropriate to check whether the order date is on a business day that is the same as or prior to the entering date?

Ordering data

Form number(Characters)Order date(Characters)Product code(Characters)Quantity(Number)Customer code(Characters)

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 (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.