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?