Consider the following SQL query.
SELECT emp_name FROM employees WHERE salary > 20000Which among the following steps of query processing will convert the above query to the given relational algebra expression?
Evaluation Engine
Parser and Translator
Optimizer
Execution Plan
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 16 Oct 2022, in the September 2022 term: 15 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 16 Oct 2022 at a glance |
|---|---|
| Term | September 2022 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 15 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 8 |
| MSQ | 5 |
| Numerical | 2 |
| Official paper | IIT M QUIZ 1 FOUNDATION DAD DIPLOMA QPD2 16 Oct 2022 |
| Negative marking | No negative marking. |
| Updated |