Computer Science and Information Technology
GATE CSE topic:databases PYQs
Build your understanding with focused practice from past exam papers.
Questions 71–73 of 73. Imported answers require independent review unless marked reviewed.
Question 46
Open questionCSNAT2 marksNeeds review
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below.
StudentName | CourseName |
|---|---|
SA | CA |
SA | CB |
SA | CC |
SB | CB |
SB | CC |
SC | CA |
SC | CB |
SC | CC |
SD | CA |
SD | CB |
SD | CC |
SD | CD |
SE | CD |
SE | CA |
SE | CB |
SF | CA |
SF | CB |
SF | CC |
The following query is made on the database
The number of rows in
is __________.Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 46
Open questionCSNAT2 marksNeeds review
Consider the following database table named
.player | country | goals |
|---|---|---|
Klose | Germany | 16 |
Ronaldo | Brazil | 15 |
G Müller | Germany | 14 |
Fontaine | France | 13 |
Pelé | Brazil | 12 |
Klinsmann | Germany | 11 |
Kocsis | Hungary | 11 |
Batistuta | Argentina | 10 |
Cubillas | Peru | 10 |
Lato | Poland | 10 |
Lineker | England | 10 |
T Müller | 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 __________.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 49
Open questionCSNAT2 marksNeeds review
In a B+ tree, if the search-key value is 8 bytes long, the block size is 512 bytes and the block pointer size is 2 bytes, then the maximum order of the B+ tree is __________.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer