PREVIOUS YEAR SOLVED PAPERS MCQ - GATE 2019

61 A relational database contains two tables Student and Performance as shown below:

Roll_no.	Student_name
1	Amit
2	Priya
3	Vinit
4	Rohan
5	Smita

Performance

Roll_no	Subject_code	Marks
1	A	86
1	B	95
1	C	90
2	A	89
2	C	92
3	C	80

The primary key of the Student table is Roll_no. For the Performance table, the columns Roll_no. and Subject_code together form the primary key. Consider the SQL query given below:
SELECT S.Student_name, sum(P.Marks)
FROM Student S, Performance P
WHERE P.Marks > 84
GROUP BY S.Student_name;
The number of rows returned by the above SQL query is ________.

Note – Numerical Type question

Total 5 different student names all 5 group records in result. (In where condition no condition over Roll_no so query produces all groups.)

62 Consider the following C program:

#include

int main(){
float sum = 0.0, j = 1.0, i = 2.0;
while (i/j > 0.0625){
j = j + j;
sum = sum + i/j;
printf("%f\n", sum);
}
return 0;
}
The number of times the variable sum will be printed, when the above program is executed, is _________________.

Note: Numerical Type question.

According to “while” loop,

Initially i = 2.0, j = 1.0
i / j = 2.0 / 1. 0 = 2.0 > 0.0625

j = j + j
j = 2.0
printed sum = 0.0

Second time,
i / j = 1 > 0.0625
j = 4
printed sum = 0.0

Third time,
i / j = 0.5 > 0.0625
j = 8
printed sum = 0.0

Fourth time,
i / j = 0.25 > 0.0625
j = 16
printed sum = 0.0

Fifth time,
i / j = 0.125 > 0.0625
j = 32
printed sum = 0.0

Sixth time,
i / j = 0.0625 = 0.0625
It violates the greater then condition.
This time while loop will not execute.

63 Consider the following C program:

#include

int main()
{
int a[] = {2, 4, 6, 8, 10};
int i, sum = 0, *b = a + 4;
for (i = 0; i < 5; i++)
sum = sum + (*b – i) – *(b – i);
printf (“%d\n”, sum);
return 0;
}
The output of the above C program is __________.

Note – Numerical Type question

Given, “for” loop will run from i=0 to 4.
i = 0
sum = 0+ 10 – 10 = 0
i = 1
sum = 0 + 9 – 8 = 1
i = 2
sum = 1 + 8 – 6 = 3
i = 3
sum = 3 + 7 – 4 = 6
i = 4
sum = 6 + 6 – 2 = 10
Now, loop terminate and value of sum (i.e., 10) will be printed. So, The output of above C program is 10.