ITPEC FE Morning April 2023 Question 30
ITPEC FE Morning April 2023 — Question 30 of 80
Database Index Purpose — an index speeds up data retrieval by providing efficient access to storage locations.
An index is a data structure (typically a B-tree) created on a column to accelerate search operations — instead of scanning every row, the DBMS jumps directly to the relevant location.
Why not others:
- (a) — describes partitioning (distributing a table across disks), not indexing
- (c) — describes a UNIQUE constraint, not an index; indexes can allow duplicates
- (d) — describes referential integrity (foreign key constraint), not indexing
Key rule: Index = faster search. It does NOT enforce uniqueness or integrity — those are separate constraints.
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 FE past-paper collection or Report an issue.