Consider the relation Student (name, sex, marks), where the primary key is…

PYQ GATE 2004

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: r is the rename operator).

image.png

  1. A.

    names of girl students with the highest marks

  2. B.

    names of girl students with more marks than some boy student

  3. C.

    names of girl students with marks not less than some boy students

  4. D.

    names of girl students with more marks than all the boy students

Attempted by 186 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…