Question 1 of 30
A database administrator is tasked with retrieving employee records from the \"Employees\" table where the department is either \'Sales\' or \'Marketing\', and the employee\'s salary is greater than $50,000. Which SQL statement correctly implements this requirement using the WHERE clause?
SELECT * FROM Employees WHERE (Department = 'Sales' OR Department = 'Marketing') AND Salary > 50000;
SELECT * FROM Employees WHERE Department IN ('Sales', 'Marketing') AND Salary > 50000;
SELECT * FROM Employees WHERE (Department = 'Sales' AND Salary > 50000) OR (Department = 'Marketing' AND Salary > 50000);
SELECT * FROM Employees WHERE Department = 'Sales' OR (Department = 'Marketing' AND Salary > 50000);

Preparing for Oracle Database Foundations? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free