Neco 2024 Data Processing Question 33

Practice objective / multiple choice question 33 from the 2024 Neco Data Processing examination.

Neco 2024 Data Processing Objective / Multiple Choice Medium Difficulty
Question 33 NECO • 2024 • DATA_PROCESSING • objective

The table Students(SID, Name, Dept) has 120 rows, of which 30 rows have Dept = 'CS'. The table Enrollments(SID, CourseCode, Grade) has 480 rows, and at most 40\% of the rows have Grade = 'A'. Each student enrolls in at most 5 courses. What is the maximum possible number of rows returned by the natural join Students \(\bowtie\) Enrollments when the join condition is Dept = 'CS' and Grade = 'A' ?

Answer Options

A. 30
B. 120
Correct Answer C. 150
D. 192
Correct Answer
C
Correct Option:
150

About This Question

This is Neco 2024 Data Processing Question 33. It is one of the objective questions from the 2024 Neco Data Processing examination.

Difficulty level: Medium .

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