Questions Bank | Page 122419

Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)

Department (DepartmentID, DepartmentName, #ManagerID)

Project (ProjectID, ProjectName, StartDate, EndDate, Budget)

Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)

Employee (EmployeeID) is the primary key.
Department (DepartmentID) is the primary key.
Project (ProjectID) is the primary key.
Employee_Project (#EmployeeID, #ProjectID) is a composite primary key (many-to-many relationship between Employee and Project).
Employee(#DepartmentID) REFERENCES Department(DepartmentID): An employee belongs to a department.
Department(#ManagerID) REFERENCES Employee(EmployeeID): A manager is an employee.
Employee_Project(#EmployeeID) REFERENCES Employee(EmployeeID)
Employee_Project(#ProjectID) REFERENCES Project(ProjectID)

Which query selects employees whose salary is greater than at least one employee in department 2?

A) SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);

B) SELECT * FROM Employee WHERE Salary > (SELECT MAX(Salary) FROM Employee WHERE DepartmentID = 2);

C) SELECT * FROM Employee WHERE Salary = ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);

D) SELECT * FROM Employee WHERE Salary < (SELECT Salary FROM Employee WHERE DepartmentID = 2);

❌

✅

❌

View this question

Crowdly