Database Management Systems · Quiz 1 · 27 Oct 2024 · September 2024 term

Question 5: Consider the table Faculty(ID, Name, Department, Salary) …

Question 5

+4 marksOne correct option

Consider the table Faculty(ID, Name, Department, Salary) and the two queries Q1 and Q2 given below. Our goal is to find the IDs of faculty members whose salary is greater than the highest salary in the Computer Science department. Assume that 'Computer Science' department has more than one faculty member. Which of the following queries will give the required output?

Q1:

sql

1select F.ID
2from Faculty as F
3where F.salary>All(select distinct salary
4                 from Faculty as T
5                 where T.department='Computer Science')

Q2:

sql

1select F.ID
2from Faculty as F
3where not exists(select *
4               from Faculty as T
5               where T.department='Computer Science' and T.salary>=F.salary)

A
Q1 is correct but Q2 is wrong
B
Q2 is correct but Q1 is wrong
C
Both Q1 and Q2 are wrong
D
Both Q1 and Q2 are correct

Show answer

Correct answer

D
Both Q1 and Q2 are correct

See the whole paper Take it as a mock test

Question 5 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 27 Oct 2024, in the September 2024 term (IIT M DIPLOMA AN EXAM QDD2 27 Oct 2024). It carries 4 marks.

Question 5: Consider the table Faculty(ID, Name, Department, Salary) …

Question 5

More questions from this paper