Question 1
Write an SQL query to find the room number and building name of the classroom that has a capacity of more than 50 students.
Question 2
Write an SQL query to find the player IDs of the players whose name ends with 'a'.
Question 3
Write an SQL query to find the match dates where the host team score is not between 3 and 5.
6 more questions in this paper
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.
More on the DBMS OPPE 2 Jan 2026 paper
The IIT Madras BS Database Management Systems (DBMS) OPPE 2 paper sat on Jan 2026, in the January 2026 term: 9 questions for 130 marks in 180 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 OPPE 2 Jan 2026 at a glance |
|---|---|
| Term | January 2026 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 9 |
| Marks | 130 |
| Duration | 180 min |
| Programming | 9 |
| Official paper | OPPE 2, January 2026 |
| Negative marking | No negative marking. |
| Updated |