WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);
A. All columns and rows belong to table employee
B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” or 2013-01-24 as a “start_date)
C. Both a and b
D. None of the above
Answer:A
WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);
A. All columns and rows belong to table employee B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” or 2013-01-24 as a “start_date) C. Both a and b D. None of the above
Explanation: “WHERE” clause is used to filter out unwanted rows therefore in above query only those rows will be selected which contain title as ‘HEAD TELLER’ or start_date 2013-01-24.