 
			 
			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 | |