Which of these can be used to determine if a student had earned a passing grade of an "A", "B", or "C", assuming that the grade is in the string variable grade?
A) grade Like "["A" or "B" or "C"]"
B) grade Like "['A' or 'B' or 'C']"
C) grade Like "[ABC]"
D) grade Like "A or B or C"

Question

Quizplus · Accepted Answer

Option C uses a character set to match any of the letters A, B, or C in the variable grade. This is the proper syntax for matching any one of several characters in SQL. Options A and B are incorrect because they use invalid syntax for matching multiple characters, and option D is incorrect because it doesn't use quotes around the individual letter options.

Which of These Can Be Used to Determine If a Student