← Quiz: Relational Algebra: all 15 questions
Quiz: Relational Algebra · Question 2 of 15
A table has 10 rows. π dept (table) returns 4 rows. Why?
A table has 10 rows. π dept (table) returns 4 rows. Why?
- A.Projection always returns fewer rows than selection
- B.Six rows had NULL in dept
- C.Projection removes duplicate rows, and there are only 4 different departments
- D.Projection keeps only the first 4 rows
Answer & explanation
Correct answer: Projection removes duplicate rows, and there are only 4 different departments
Relational algebra works on sets, so repeated values appear once.
Can you get the rest right without peeking?
Take the timed Quiz: Relational Algebra quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →