Question 33 Consider the table employee(empId, name, department, salary) and the two queries Q1,Q2 below. Assuming that department 5 has more than one employee, and we […]

Question 34 Consider the following database table named water_schemes : The number of tuples returned by the following SQL query is _________. with total(name, capacity) as […]

Question 35 Consider the following database table named top_scorer. SELECT ta.player FROM top_scorer AS ta WHERE ta.goals > ALL (SELECT tb.goals FROM top_scorer AS tb WHERE […]

Question 38 Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on […]