CRC
August 30, 2024Sliding-Window-Protocol
August 31, 2024Relational-Algebra
| Question 17 |
Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least one boy and one girl. What does the following relational algebra expression produce? (Note: p is the rename operator).
The condition in join is “(sex = female ^ x = male ^ marks ≤ m)”
| names of girl students with the highest marks
| |
| names of girl students with more marks than some boy student | |
| names of girl students with marks not less than some boy students
| |
| names of girl students with more marks than all the boy students |
Question 17 Explanation:
In the operator ‘-‘ between the two subexpression gives the names of all female students whose marks are greater than the all the male students of the class.
Correct Answer: D
Question 17 Explanation:
In the operator ‘-‘ between the two subexpression gives the names of all female students whose marks are greater than the all the male students of the class.