ITPEC IP April 2018 Question 28
ITPEC IP April 2018 — Question 28 of 100
A duplicate check searches existing records to confirm that the new order number has not already been used. Because the order number must uniquely identify a record, finding the same value in the master file means the input must be rejected or corrected.
Answer (a)
Why not others:
- a format check verifies the character pattern or data representation
- a limit check verifies that a value lies within an allowed range
- a logical check verifies consistency among related fields or conditions
Key rule: Use a duplicate or uniqueness check for key values; format, range, and logical checks validate different properties.
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 IP past-paper collection or Report an issue.