Gate CS-2012 Question Paper With Solutions

Q. 51 Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?

Table A
Id   Name    Age
----------------
12   Arun    60
15   Shreya  24
99   Rohit   11


Table B
Id   Name   Age
----------------
15   Shreya  24
25   Hari    40
98   Rohit   20
99   Rohit   11


Table C
Id   Phone  Area
-----------------
10   2200   02  
99   2100   01
SELECT A.id 
FROM   A 
WHERE  A.age > ALL (SELECT B.age 
                    FROM   B 
                    WHERE  B. name = "arun")

(A) 4

(B) 3

(C) 0

(D) 1

Answer: (B)

Explanation:Gate CS-2012 Question Paper With Solutions

 

Learn More:   Gate ME-2018-1 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here