PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will accomplish this?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply