ITPEC IP April 2018 Question 26
ITPEC IP April 2018 — Question 26 of 100
Lists A and C can be created, but B cannot. Sales records contain customer, product, date, and amount, so they can be joined to names and aggregated to find high-spending customers or rank products by monthly sales. No stock quantity or stockout history exists in the three tables.
Answer (c)
Why not others:
- A is possible by filtering dates, grouping by customer, and summing sales amount
- C is possible by filtering the previous month, grouping by product, and ranking summed amounts
- B requires inventory or availability data that is absent
Key rule: A query can derive only information represented directly or computably by the available attributes and relationships.
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.