Question 1
Write an SQL query to find the name and quantity of the products whose name ends with the character 'b' and contains at least five characters.
Question 2
Write an SQL query to find the titles of the book, that were published after 2005 and author's first name is 'Subrata' and lastname is 'Saha'.
Question 3
Write an SQL query to find the referee id, number of matches conducted by referee 'Tony Joseph Louis'.
5 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 30 Mar 2025 paper
The IIT Madras BS Database Management Systems (DBMS) OPPE 2 paper sat on 30 Mar 2025, in the January 2025 term: 8 questions for 8 marks in 90 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 30 Mar 2025 at a glance |
|---|---|
| Term | January 2025 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 8 |
| Marks | 8 |
| Duration | 90 min |
| Programming | 8 |
| Official paper | OPPE 2, 30 Mar 2025 |
| Negative marking | No negative marking. |
| Updated |