试题详情
多项选择题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
  • 关注下方微信公众号,在线模考后查看

热门试题