Database-Management-System

Question 190

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
     FROM employees
     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?

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

Database-Management-SystemSQLGATE 2014 [Set-1]Video-Explanation

Question 190 Explanation:

The given SQL query will display the last names and hire-dates of all latest hires in their respective departments in the location ID 1700. So, correct option is (B).

Correct Answer: B

Question 190 Explanation:

The given SQL query will display the last names and hire-dates of all latest hires in their respective departments in the location ID 1700. So, correct option is (B).

hetram meena

0 0 votes

Article Rating

0 Comments

Inline Feedbacks

View all comments