DBMS papers, exam by exam
Worked out from 62 DBMS papers of the IIT Madras BS degree, 2022–2026 — Quiz 1, Quiz 2, End Term and OPPE 2 — and their 1,046 questions: how long each exam is, how many marks it carries, which kinds of question it asks and how often a wrong answer costs marks. Every paper is on DBMS PYQs, with its answer key and as a timed mock test.
| Feature | DBMS papers at a glance |
|---|---|
| Papers | 62 |
| Questions | 1,046 |
| Exams | 4 |
| Years | 2022–2026 |
| Negative marking | None in these papers |
A typical DBMS paper, by exam
| Exam | Papers | Questions | Marks | Time | Question types |
|---|---|---|---|---|---|
| DBMS Quiz 1 | 14 | 15 | 50 | 120 min | 62% MCQ, 21% MSQ, 17% numerical |
| DBMS Quiz 2 | 16 | 15 | 50 | 120 min | 51% MCQ, 33% MSQ, 15% numerical |
| DBMS End Term | 24 | 20 | 50 | 180 min | 51% MCQ, 30% MSQ, 18% numerical |
| DBMS OPPE 2 | 8 | 9 | 9 | 90 min | 100% programming |
The middle value of each exam’s papers; a sitting can differ by a question or two.
Question types in DBMS
| Question type | Questions | Share |
|---|---|---|
| Single choice (MCQ) | 522 | 50% |
| Multiple choice (MSQ) | 282 | 27% |
| Numerical answer | 168 | 16% |
| Programming | 73 | 7% |
| Written answer | 1 | 0% |
Most DBMS questions carry 2, 3 or 4 marks. None carries negative marks in its paper.
What each DBMS exam covers
| Exam | What it covers |
|---|---|
| Quiz 1 | Quiz 1 is held at the end of week 4 of the term and covers the content of weeks 1–4. |
| Quiz 2 | Quiz 2 is held at the end of week 8 and covers the content of weeks 1–8, with the weight on weeks 5–8. |
| End Term | The End Term exam covers the whole course, all twelve weeks, in 1.5 hours per course. |
| OPPE 2 | OPPE is the online proctored programming exam, solved by writing and running code. |
How to practise DBMS
- Start with the newest papers of the exam you are sitting: every DBMS paper, by exam and year.
- Open a paper in learning mode to see each answer and its explanation as you go.
- A few days before the exam, take one as a timed mock test: it is marked the moment you submit, with the paper’s own marks and negative marks.
- Check your answers against the answer keys, then review the questions you got wrong.
Latest DBMS papers
| Paper | Exam | Term | Questions | Marks | Time | Practise |
|---|---|---|---|---|---|---|
| DBMS End Term 13 Sept 2026 | End Term | May 2026 term | 18 | 44 | 180 min | Mock test — DBMS End Term 13 Sept 2026 |
| DBMS Quiz 2 16 Aug 2026 | Quiz 2 | May 2026 term | 16 | 50 | 120 min | Mock test — DBMS Quiz 2 16 Aug 2026 |
| DBMS Quiz 1 19 Jul 2026 | Quiz 1 | May 2026 term | 16 | 50 | 120 min | Mock test — DBMS Quiz 1 19 Jul 2026 |
| DBMS End Term 10 May 2026 (Set 1) | End Term | January 2026 term | 20 | 50 | 180 min | Mock test — DBMS End Term 10 May 2026 set 1 |
| DBMS End Term 10 May 2026 (Set 2) | End Term | January 2026 term | 20 | 50 | 180 min | Mock test — DBMS End Term 10 May 2026 set 2 |
| DBMS Quiz 2 12 Apr 2026 | Quiz 2 | January 2026 term | 15 | 50 | 120 min | Mock test — DBMS Quiz 2 12 Apr 2026 |
| DBMS Quiz 1 15 Mar 2026 | Quiz 1 | January 2026 term | 15 | 50 | 120 min | Mock test — DBMS Quiz 1 15 Mar 2026 |
| DBMS OPPE 2 Jan 2026 | OPPE 2 | January 2026 term | 9 | 130 | 180 min | Mock test — DBMS OPPE 2 Jan 2026 |
Frequently asked questions
How many questions are in the IITM BS DBMS Quiz 1?
A typical DBMS Quiz 1 has 15 questions for 50 marks in 120 minutes, going by its 14 papers here. See every DBMS Quiz 1 paper.
How many questions are in the IITM BS DBMS Quiz 2?
A typical DBMS Quiz 2 has 15 questions for 50 marks in 120 minutes, going by its 16 papers here. See every DBMS Quiz 2 paper.
How many questions are in the IITM BS DBMS End Term?
A typical DBMS End Term has 20 questions for 50 marks in 180 minutes, going by its 24 papers here. See every DBMS End Term paper.
How many questions are in the IITM BS DBMS OPPE 2?
A typical DBMS OPPE 2 has 9 questions for 9 marks in 90 minutes, going by its 8 papers here. See every DBMS OPPE 2 paper.
Is there negative marking in IITM BS DBMS?
None of the 1,046 DBMS questions here carries negative marks in its paper, so an unanswered question and a wrong one both score zero.
What types of questions come in IITM BS DBMS?
Across every DBMS paper here: 50% MCQ, 27% MSQ, 16% numerical, 7% programming. Most questions carry 2, 3 or 4 marks.