Microsoft
70-433 · Question #41
70-433 Question #41: Real Exam Question with Answer & Explanation
The correct answer is C. CHECK ((CreditLimt = 0 AND Verified = 0) OR (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1)). See the full explanation below for the reasoning.
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?
Options
- ACHECK (CreditLimt BETWEEN 1 AND 10000)
- BCHECK (Verified = 1 AND CreditLimt BETWEEN 1 AND 10000)
- CCHECK ((CreditLimt = 0 AND Verified = 0) OR (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1))
- DCHECK ((CreditLimt = 0 AND Verified = 0) AND (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1))
Community Discussion
No community discussion yet for this question.