Test Index

GATE Computer Science (CS) 2014 Shift 1 Solved Paper

© examsnet.com

Question : 64 of 65

Marks: +1, -0

Given the following schema:

employees(emp-id, first-name, last-name, hire-date,

dept-id, salary)

departments(dept-id, dept-name, manager-id, location-id)

You want to display the last names and hire dates of all latest hires in their respective departments

in the location ID 1700. You issue the following query:

SQL>SELECT last-name, hire-date

WHERE (dept-id, hire-date) IN

(SELECT dept-id, MAX(hire-date)

FROM employees JOIN departments USING(dept-id)

WHERE location-id = 1700

GROUP BY dept-id);

What is the outcome?

It executes but does not give the correct result
It executes and gives the correct result.
It generates an error because of pairwise comparison
It generates an error because the GROUP BY clause cannot be used with table joins in a subquery.

Go to Question:

Prev Question

Next Question