WAEC Data Processing 2023 Objective — Question 35

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

Columns 2 and 3 in Table 1 cannot be used as primary key because both fields contain A. the same datatype.

A. the same datatype
B. only strings and numbers respectively
C. duplicate valuesCorrect
D. different datatypes

Explanation

A primary key is a field in a database that contains unique values for every different record; there can be no duplicates. Since columns 2 (House) and 3 (Age) in Table 1 contain duplicate values, they cannot be used as primary key.

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 2023 Objective More Data Processing past papers