WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;
A. All columns
B. Only those columns which are mention with “SELECT” clause
C. Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date as 2008-11-24
D. None of the above
Answer:A
WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;
A. All columns B. Only those columns which are mention with “SELECT” clause C. Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date as 2008-11-24 D. None of the above
Explanation: “WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.