User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of
the following criteria:
The employee’s hire date (HIREDATE) is before 1999 and the employee’s salary (SALARY) is
less than $40,000.00 a year.
The employee has attended university
Which SQL statement will accomplish this?
A.
SELECT * FROM employee
WHERE (hiredate < ‘1999-01-01’ AND salary < 40000)
OR (education = ‘University’)
B.
SELECT * FROM employee
WHERE (hiredate < ‘1999-01-01’) OR (salary < 40000)
OR (education = ‘University’)
C.
SELECT * FROM employee
WHERE (hiredate < ‘1999-01-01’ OR (salary < 40000
AND (education = ‘University’)
D.
SELECT * FROM employee
WHERE (hiredate < ‘1999-01-01’ AND salary < 40000
AND (education = ‘University’)
Explanation: