YouneedtodesigntherestrictionsontheBank.Customerstable.Whichthreeactionsshouldyouperform?（）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.

多项选择题

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.

MCITP(70-441)