Gate CS-2017-1 Question Paper With Solutions

Q. 59 Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below.

The following query is made on the database.

T1 ← π_CourseName(σ_{StudentName=’SA’}(CR))

T2 ← CR ÷ T1

The number of rows in T2 is ________.

Note: This questions appeared as Numerical Answer Type.

(A) 2

(B) 3

(C) 4

(D) 5

Answer: (C)

Explanation: