Consider the following database Student:

Student

Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded
1205 Mohan Garg 12th 99.9 50000
1009 Dushyant Singh 10th 98.7 45000
1101 Swati Rana 11th 95.4 30000
945 Ravindra Saini 9th 97.4 35000
1015 Ritika Thakur 10th 98.6 40000

1. The marks obtained by the student with RollNo. 1101 is?

2. What is the name of the student, who has got the highest marks and what is the amount of scholarship awarded to him/her?

3. How many records are there in the table?

4. How many fields are there in the table?

6 views

1 Answers

1. 95.4

2. Mohan Garg and scholarship awarded is 50000.

3. 5

4. 6

6 views