WAEC Data Processing 2025 Objective — Question 36

Question 36 of 40 from the West African Examinations Council (WAEC) Data Processing 2025 Objective paper, with the correct answer and a full explanation.

To create a one-to-one relationship in a database, it is necessary that

A. both primary and foreign key fields should have multiple key index
B. both primary and foreign key fields should have unique key indexCorrect
C. only the foreign key field should have a unique index
D. only the primary key field should have a unique index

Explanation

A one-to-one relationship in a database means each record in Table A relates to exactly one record in Table B, and vice versa. This requires both the primary key and the foreign key to have a unique index so each value appears only once in both tables.

Sign up free to unlock

Score tracking
Practice history
Saved questions
Progress dashboard
Personalized sessions
Weak-topic breakdown

…and/or go further with premium services and No Ads.

Create free account

More questions from Data Processing 2025 Objective More Data Processing past papers