Gate CS-2013 Question Paper With Solutions

Q. 35 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"

 

Gate CS-2013 Question Paper With Solutions

(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: (A)

Explanation:

Gate CS-2013 Question Paper With Solutions

Gate CS-2013 Question Paper With Solutions

Gate CS-2013 Question Paper With Solutions

Learn More:   Gate CS-2004 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here