The relation Students(Name, Total_Marks) contains the names and marks of different students where no two students have the same name or total marks. What will the following SQL query return?
Names of the students with the first four highest marks
Name of the student with the 4th highest mark
Names of the students with the first three highest marks
Name of the student with the 3rd highest mark
Consider a relation R(A, B, C, D, E) with following functional dependency set FD : {A → BC, CD → E, B → D, E → A} What is the highest normal form of R?
1NF
2NF
3NF
BCNF
Consider the relation R(A, B, C, D, E, F) with dependency set FD: {AB → C, E → F, AC → B, BC → A, B → D, AD → E} Following are the two decompositions of R: ●D1 : {AB, BC, EF, ABDE}●D2 : {ABC, ADF, ACDE} Choose the correct option
D1 is lossless decomposition but not D2
D2 is lossless decomposition but not D1
Both are lossless decomposition
Both are lossy decomposition
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 16 Aug 2026, in the May 2026 term: 16 questions for 50 marks in 120 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | DBMS Quiz 2 16 Aug 2026 at a glance |
|---|---|
| Term | May 2026 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 16 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 8 |
| Written | 4 |
| MSQ | 4 |
| Official paper | Database Management Indian Institute Of Technology, Madras - Bs In Data Science/ Electronic Systems Systems 14 Aug 26 |
| Negative marking | No negative marking. |
| Updated |
