How to select all data from the student table where the name starts with the letter 'r'?

How to select all data from the student table where the name starts with the letter 'r'?

  1. a) SELECT * FROM student WHERE name LIKE 'r%';
  2. b) SELECT * FROM student WHERE name LIKE '%r%';
  3. c) SELECT * FROM student WHERE name LIKE '%r';
  4. d) SELECT * FROM student WHERE name LIKE '_r%';

From the Sonali & Janata Bank Assistant Database Administrator September 2021 – Preliminary (AUST) exam, question 19 of 93.

More from this paper