Which of the following statement fragments will only allow a CreditLimit of $5,000, $7,500, or $15,000?
A) (CreditLimit IN (5000, 7500, 15000))
B) CHECK ((5000, 7500, 15000))
C) CHECK (CreditLimit LIKE (5000, 7500, 15000))
D) CHECK (CreditLimit IN (5000, 7500, 15000))

Question

Quizplus · Accepted Answer

The syntax for allowing specific values in a column is using the "IN" keyword followed by a list of values inside parentheses. Therefore, option D's syntax of "CHECK (CreditLimit IN (5000, 7500, 15000))" is the correct choice. Option A also uses the correct syntax but in a different format. Option B is incorrect as it does not use the correct syntax for the "CHECK" constraint. Option C uses the "LIKE" keyword, which is used for pattern matching, and is not appropriate for this situation.

Which of the Following Statement Fragments Will Only Allow a CreditLimit