CIW Exam Questions

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

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 = %