Terms Used in Information Management

CAPE IT · UNIT 2 · MODULE 1 · OBJ. 1
Step 1 of 3
EXPLORE IN 3D

The data hierarchy in 3D

Move up from the bit to the database.

REVISION · PAST-PAPER PRACTICE

Test yourself

Multiple-choice items in Paper 1 style and structured questions in Paper 2 style, adapted from CAPE Information Technology Unit 2 past papers. Your score and answers are saved on this device. When you have finished, submit them to your teacher at the end of this section.

MCQ best –Structured –

Paper 1 practice · 8 multiple-choice items

Choose one answer for each item, then check. Aim for 80% or better.

EduTech practice item · Module 1 Obj. 1 (terms tested in CAPE U2 P2 2023 Q1(a) and 2025 Q1(b))
1. Which list shows the data hierarchy from the SMALLEST unit to the LARGEST?
Answer: A. Characters make up a field, fields make up a record, related records form a file (table), and related files form a database.
Based on CAPE U2 P2 2023 Q1(a)
2. In a table named ORDERS, one complete row such as 1045 | C12 | Mango | 30 is called a
Answer: B. A row holds all the data about ONE order, so it is a record (also called a tuple).
Based on CAPE U2 P2 2025 Q1(b)(i)
3. A column that holds the same kind of item for every row, such as Quantity, is a
Answer: C. Each column is a field: a single item of information that appears in every record.
Adapted from CAPE U2 P1 2019 Item 29; 2020 Item 25
4. Which of the following are data types that a database field can be given?
I. Boolean (Yes/No)
II. Object (e.g. a picture)
III. Attribute
Answer: A. Boolean and object (OLE/BLOB) are data types. An attribute is another name for a field, not a data type.
Adapted from CAPE U2 P1 2022 Item 6
5. Which of these kinds of data can be stored in a modern database?
I. Text
II. Audio clips
III. Images
Answer: D. Modern databases store text, numbers, dates and multimedia such as audio and images (as BLOB/object fields).
EduTech practice item · Module 1 Obj. 1
6. Which statement BEST describes a database management system (DBMS)?
Answer: B. The database is the organised data; the DBMS (e.g. MySQL, Microsoft Access) is the software that manages it.
EduTech practice item · Module 1 Obj. 1
7. In relational database terms, a tuple is the same as a
Answer: D. Tuple = row = record. Attribute = column = field. Relation = table.
EduTech practice item · Module 1 Obj. 1
8. A school stores 1 842 exam scores. The principal is told “the Form 6 pass rate rose from 68% to 81%”. This statement is an example of
Answer: A. Raw scores are data. Once processed (summarised into a pass rate and compared) they become information that supports a decision.

Paper 2 practice · structured questions (14 marks)

Write a full answer to each part, then show the mark scheme and tick every point you earned. Marks for a part are capped at its maximum. Mark schemes are EduTech’s own; CXC does not publish them.

Based on CAPE U2 P2 May/June 2023, Question 1(a) and 2025, Question 1(b)

Question 1 [8 marks]

FreshSqueeze buys fruit from farmers and sells juice to shops. Part of its DELIVERIES table is shown.
DelNoShopIDJuiceLitres
D101S07Guava20
D102S03Sorrel15
D103S07Passion fruit30

(a) Using the table, give ONE example of EACH of the following: a field, a record, the name of the file. [3]

MARK SCHEME (a) · max 3

(b) Using an example from FreshSqueeze, explain the difference between data and information. [2]

MARK SCHEME (b) · max 2

(c) Distinguish between a database and a database management system (DBMS). Name ONE DBMS FreshSqueeze could use. [3]

MARK SCHEME (c) · max 3
EduTech practice question in Paper 2 style · Module 1 Obj. 1

Question 2 [6 marks]

A community library is moving its members’ details from index cards into a database.

(a) Name the FOUR levels of the data hierarchy from smallest to largest, and describe each briefly. [4]

MARK SCHEME (a) · max 4

(b) Explain why each member record should contain a field whose value is different for every member. [2]

MARK SCHEME (b) · max 2

Submit to your teacher

Send your multiple-choice choices and written answers to your teacher for marking. Your teacher will also see whether you opened the mark scheme or checked your answers before submitting. You can submit again if you improve your answers.

Items are adapted from CAPE® Information Technology Unit 2 Papers 01 and 02 (2019–2026) for practice. © Caribbean Examinations Council for the original papers.