Which of the following components of the Database Management System (DBMS) is primarily responsible for generating and selecting the most cost-effective execution plan for a given SQL query?
Parser and Translator
Query Optimizer
Evaluation Engine
Buffer Manager
Consider the relation Delivery_Fee:
30.00
35.00
40.00
42.00
Consider the following SQL statements are executed in sequence on a newly created table Shipment:
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 1 paper sat on 19 Jul 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 1 19 Jul 2026 at a glance |
|---|---|
| Term | May 2026 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 16 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 9 |
| MSQ | 5 |
| Written | 2 |
| Official paper | Database Management Systems 16 Jul 26 |
| Negative marking | No negative marking. |
| Updated |
