WHERE end_date IS NULL AND (title=’teller’ OR start_date < ‘2007-01-01’)
A. Only those rows will be selected whose” end_date” should be NULL
B. Only those rows are selected whose “TITLE” should be ‘teller’
C. Only those employee will be selected who joined the organisation prior to 2007
D. All of the above
Answer:A
WHERE end_date IS NULL AND (title=’teller’ OR start_date < ‘2007-01-01’)
A. Only those rows will be selected whose” end_date” should be NULL B. Only those rows are selected whose “TITLE” should be ‘teller’ C. Only those employee will be selected who joined the organisation prior to 2007 D. All of the above
Explanation: None.