Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Consider the Registration relation shown in the exhibit.

Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Consider the Registration relation shown in the exhibit.

Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

A.
SELECT * FROM
Registration WHERE
Course_Code = #

B.
SELECT * FROM
Registration WHERE
Course_Code LIKE _

C.
SELECT * FROM
Registration WHERE
Course_Code LIKE %

D.
SELECT * FROM
Registration WHERE
Course Code = %



Leave a Reply 1

Your email address will not be published. Required fields are marked *


dr_phizz

dr_phizz

C is closest but should be LIKE M%