Test Index

GATE Computer Science (CS) 2017 Shift 2 Solved Paper

© examsnet.com

Question : 56 of 65

Marks: +1, -0

Consider the following database table named top_scorer.

player	country	Goals
Klose	Germany	16
Ronaldo	Brazil	15
G miller	Germany	14
Fontaine	France	13
Pele	Brazil	12
Klinsmann	Germany	11
Kocsis	Hungary	11
Batistuta	Argentina	10
Cubillas	Peru	10
Lato	Poland	10
Lineker	England	10
T Miller	Germany	10
Rahn	Germany	10

Consider the following SQL query:

SELECT ta.player FROM top scorer AS ta

WHERE ta.goals >All (SELECT tb.goals

FROM top_scorer AS tb

WHERE tb.country = ‘Spain’)

AND ta.goals >Any (SELECT tc.goals

FROM top_scorer AS tc

WHERE tc.country = ‘Germany’)

The number of tuples returned by the above SQL query is ______.

Your Answer:

Go to Question:

Prev Question

Next Question