Which of the following is the correct sequence for query processing?
Query → Parser and Translator → Evaluation Engine → Optimizer → Query Output
Query → Optimizer → Evaluation Engine → Parser and Translator → Query Output
Query → Parser and Translator → Optimizer → Evaluation Engine → Query Output
Query → Evaluation Engine → Parser and Translator → Optimizer → Query Output
1-A, 2-B, 3-C
1-B, 2-A, 3-C
1-B, 2-C, 3-A
1-C, 2-A, 3-B
A relational database contains two separate tables called Employee and Department.
The Employee table has the attributes (Emp_ID, Name, Dept_ID, Salary) and the Department table contains the attributes (Dept_ID, Dept_Name).
The following insert statements were executed to populate the tables:
Insert into Employee values(001,'Mark',1,80000)Insert into Employee values(002,'Finn',2,60000)Insert into Employee values(003,'Rory',1,90000)Insert into Department values(1,'Forensics')Insert into Department values(2,'Cyber Crime')How many rows and columns will be returned by the following SQL query?
select *from Employee, Departmentwhere salary>650004 rows and 6 columns
2 rows and 5 columns
4 rows and 5 columns
2 rows and 6 columns
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 27 Oct 2024, in the September 2024 term: 14 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 27 Oct 2024 at a glance |
|---|---|
| Term | September 2024 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 14 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 8 |
| MSQ | 4 |
| Numerical | 2 |
| Official paper | IIT M DIPLOMA AN EXAM QDD2 27 Oct 2024 |
| Negative marking | No negative marking. |
| Updated |