Consider the following relational schema. Students(rollno: integer, sname:…

PYQ GATE 2013

Consider the following relational schema.

Students(rollno: integer, sname: string)
Courses(courseno: integer, cname: string)
Registration(rollno: integer, courseno: integer, percent: real)

Which of the following queries are equivalent to this query in English?

“Find the distinct names of all students who score more than 90% in the course numbered 107”

(I) SELECT DISTINCT S.sname
    FROM Students as S, Registration as R
    WHERE R.rollno=S.rollno AND R.courseno=107 AND R.percent >90

(II) ∏sname(σcourseno=107 ∧ percent>90 (Registration ⋈ Students))

(III) {T | ∃S∈Students, ∃R∈Registration (S.rollno=R.rollno ∧ R.courseno=107 ∧ R.percent>90 ∧ T.sname=S.sname)}

(IV) {<SN> | ∃SR∃RP (<SR, SN>∈Students ∧ <SR, 107, RP>∈Registration ∧ RP>90)}

  1. A.

    I, II, III and IV

  2. B.

    I, II and III only

  3. C.

    I, II and IV only

  4. D.

    II, III and IV only

Attempted by 157 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…