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.
Subscribe
Login
0 Comments