Neco 2019 Data Processing Question 45

Practice objective / multiple choice question 45 from the 2019 Neco Data Processing examination.

Neco 2019 Data Processing Objective / Multiple Choice Medium Difficulty
Question 45 NECO • 2019 • DATA_PROCESSING • objective

In a university database, relation **Students**(SID, Name, Dept) contains 120 tuples and relation **Courses**(CID, Title, Dept) contains 30 tuples. The university has three departments with the following distributions: - Dept A: 50 students, 10 courses\n- Dept B: 40 students, 12 courses\n- Dept C: 30 students, 8 courses\nIf a natural join is performed on the attribute **Dept**, how many tuples will the resulting relation contain?

Answer Options

Correct Answer A. 1220
B. 1200
C. 1260
D. 1240
Correct Answer
A
Correct Option:
1220

About This Question

This is Neco 2019 Data Processing Question 45. It is one of the objective questions from the 2019 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2019 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