

MCQOPTIONS
Saved Bookmarks
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 | |