1.

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.snameFROM Students as S, Registration as RWHERE R.rollno=S.rollno AND R.courseno=107 AND R.percent >90(II) Πsname(σcourseno=107 percent>90 (Registration Students))(III) {T | tudents, Registration ( S.rollno=R.rollnoR.courseno=107 R.percent>90 T.sname=S.sname)}(IV) {N> | ∃SR∃RP ( R, SN> ∈ Students ∧ R, 107, RP>∈ Registration ∧ RP>90)}

A. I, II, III and IV
B. I, II and III only
C. I, II and IV only
D. II, III and IV only
Answer» B. I, II and III only


Discussion

No Comment Found

Related MCQs