多选题

知识点：数据库 3/10（单选/必答） Consider the foll...

Question

知识点：数据库 3/10（单选/必答）
Consider the following schemaSTUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks)Which of the following query would display all the students where the second letter in the first name is ‘i’?

A. select first_name from students where first_name like &lsquo%i%&rsquo

B. select first_name from students where first_name like &lsquo%i_&rsquo

C. select first_name from students where first_name like &lsquo_i%&rsquo

D. select first_name from students where first_name like &lsquo_i_&rsquo