You have a table named Customer. You need to ensure that customer data in the table meets the following requirements:

credit limit must be zero unless customer identification has been verified. credit limit must be less than 10,000. Which constraint should you use?

Question

You have a table named Customer. You need to ensure that customer data in the table meets the following requirements:

credit limit must be zero unless customer identification has been verified. credit limit must be less than 10,000. Which constraint should you use?

Accepted Answer

C. CHECK ((CreditLimt = 0 AND Verified = 0) OR (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1))

Answer

A. CHECK (CreditLimt BETWEEN 1 AND 10000)

Answer

B. CHECK (Verified = 1 AND CreditLimt BETWEEN 1 AND 10000)

Answer

D. CHECK ((CreditLimt = 0 AND Verified = 0) AND (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1))

You have a table named Customer. You need to ensure that customer data in the table meets the following requirements: credit limit must be zero unless customer identification has been verified…