WHERE end_date IS NULL AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)
A. The result set contains non terminated employees who both are non tellers and started working for the bank from 2007 or later.
B. The result set contains employees who both are tellers and started working for the bank in 2007 or later.
C. The result set contains employees who are only tellers.
D. All of the above
Answer:A
WHERE end_date IS NULL AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)
A. The result set contains non terminated employees who both are non tellers and started working for the bank from 2007 or later. B. The result set contains employees who both are tellers and started working for the bank in 2007 or later. C. The result set contains employees who are only tellers. D. All of the above
Explanation: None.