Neco 2017 Data Processing Question 10

Practice objective / multiple choice question 10 from the 2017 Neco Data Processing examination.

Neco 2017 Data Processing Objective / Multiple Choice Medium Difficulty
Question 10 NECO • 2017 • DATA_PROCESSING • objective

Consider the relational schema STUDENT(AdmNo, Name, Class, Score) where AdmNo is unique for each student. Identify all candidate keys and state the primary key. Then write an SQL query that lists the names of students whose Score is above the average Score of their own Class.

Answer Options

A. Candidate key: (AdmNo, Class) (primary key). SQL: SELECT Name FROM STUDENT S WHERE Score > (SELECT AVG(Score) FROM STUDENT);
Correct Answer B. Candidate key: AdmNo (primary key). SQL: SELECT Name FROM STUDENT S WHERE Score > (SELECT AVG(Score) FROM STUDENT WHERE Class = S.Class);
C. Candidate key: Name (primary key). SQL: SELECT Name FROM STUDENT S WHERE Score > (SELECT AVG(Score) FROM STUDENT WHERE Class = S.Class);
D. Candidate key: AdmNo (primary key). SQL: SELECT Name FROM STUDENT S WHERE Score >= (SELECT AVG(Score) FROM STUDENT WHERE Class = S.Class);
Correct Answer
B
Correct Option:
Candidate key: AdmNo (primary key). SQL: SELECT Name FROM STUDENT S WHERE Score > (SELECT AVG(Score) FROM STUDENT WHERE Class = S.Class);

About This Question

This is Neco 2017 Data Processing Question 10. It is one of the objective questions from the 2017 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2017 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support