Neco 2020 Data Processing Question 3
Practice objective / multiple choice question 3 from the 2020 Neco Data Processing examination.
Consider two relations R(A,B,C) and S(B,D). Relation R contains 120 tuples, of which 45 satisfy the condition C\>10. Among these 45 tuples, the values of attribute B are distributed as follows: B=1 occurs 10 times, B=2 occurs 15 times, B=3 occurs 20 times. Relation S consists of three tuples: (1, x), (2, y) and (4, z). How many tuples are produced by the relational algebra expression \( \pi_{A}\bigl(\sigma_{C>10}(R)\bigr) \;\Join_{B}\; S \) ?
Answer Options
About This Question
This is Neco 2020 Data Processing Question 3. It is one of the objective questions from the 2020 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.