Câu 36: C2090-610: DB2 10.1 Fundamentals

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 universityWhich SQL statement will accomplish this?

1. A. SELECT * FROM employeeWHERE (hiredate < '1999-01-01' AND salary < 40000)OR (education = 'University') — đáp án hiện tại
2. B. SELECT * FROM employeeWHERE (hiredate < '1999-01-01') OR (salary < 40000)OR (education = 'University')
3. C. SELECT * FROM employeeWHERE (hiredate < '1999-01-01' OR (salary < 40000AND (education = 'University')
4. D. SELECT * FROM employeeWHERE (hiredate < '1999-01-01' AND salary < 40000AND (education = 'University')