ITPEC IP April 2024 Question 26
ITPEC IP April 2024 — Question 26 of 100
Lists A and C can be created, but list B cannot, so the correct set is A and C. The Sales table records customer, product, date, and sales amount. Joining it to Customer allows sales to be grouped by customer during a chosen period, so customers whose totals exceed a threshold can be listed for A. Joining Sales to Product and aggregating by product allows previous-month sales rankings for C.
No table contains inventory quantity, stock movements, or an out-of-stock status. The absence of a sale does not prove that a product was out of stock, so B cannot be derived.
Answer (c)
Why not others:
- (a) and (b) incorrectly include B
- (b) also includes all three despite the missing stock information
- (d) omits the derivable customer list A while including B
Key rule: A query can join, filter, and aggregate stored facts, but it cannot reliably infer a fact for which the database contains no determining data.
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.