Question 1

Which of the following is the correct sequence for query processing? Figure from the original question paper 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, Department where salary>65000