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

Question

Quizplus · Accepted Answer

The correct syntax for limiting values of a field is "CHECK (field_name IN (value1, value2, ...))". Option A has the correct syntax, options B and C have incorrect syntax, and option D has the correct syntax and limits the CreditLimit field to only the specified values of $7,500, $10,000, or $15,000.

Which of the Following Statement Fragments Will Only Allow a CreditLimit