Which of the following SQL query shall output names of all customers ending…

PYQ RPSC Programmer 2013

1. A.

   Select name from customer where name like '_Smith'

2. B.

   Select name from customer where name like '%Smith'

3. C.

   Select name from customer where name like 'Smith%'

4. D.

   Select name from customer where name like '%Smith%'

Attempted by 3 students.