Which constraint should you use?

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?

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?

A.
CHECK (CreditLimt BETWEEN 1 AND 10000)

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

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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *