Question 30 Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are did and cid respectively and […]

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 […]