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 employeeWHERE (hiredate < ‘1999-01-01’ AND salary < 40000)OR (education = ‘University’)
B. SELECT * FROM employeeWHERE (hiredate < ‘1999-01-01’) OR (salary < 40000)OR (education = ‘University’)
C. SELECT * FROM employeeWHERE (hiredate < ‘1999-01-01’ OR (salary < 40000AND (education = ‘University’)
D. SELECT * FROM employeeWHERE (hiredate < ‘1999-01-01’ AND salary < 40000AND (education = ‘University’)
|
Download Printable PDF. VALID exam to help you PASS. |
 |