当前学科:结构化查询语言(SQL)
  • 题目: 单选
    有一个名为Customers的表,需要确保表中的客户数据符合下面的条件:除非客户身份(Verified)已经过验证,否则信用限额(CreditLimt)必须为零。信用限额必须小于等于10000。应使用()约束。

      A . CHECK((CreditLimt=0 AND Verified=0)OR(CreditLimt BETWEEN 1 AND 10000 AND Verified=1)
      B . CHECK(CreditLimt BETWEEN 1 AND 10000)
      C . CHECK(Verified=1 AND CreditLimt BETWEEN1 AND 10000)
      D . CHECK(CreditLimt=0 ANDV erified=0)AND(CreditLimt BETWEEN 1 AND 10000 AND Verified=1)

    答案: <查看本题扣1积分>

    查看答案

    答案不对?请尝试站内搜索


推荐知识点: