多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?()

  • A、Design a trigger that verifies that the first names and surnames are not empty strings.
  • B、Design a check constraint that verifies that the first names and surnames are not empty strings.
  • C、Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
  • D、Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
  • E、Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.
  • F、Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
正确答案:B,C,F
答案解析:
进入题库查看解析

微信扫一扫手机做题