多项选择题
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.
相关考题
-
多项选择题
Youneedtodesignthestorageoftheloanresponsemessage.Whichactionsoractionsshouldyouperform?（）
A.Use the xml data type to store the message.
B.Use a user-defined data type to store the message.
C.Use the nvarchar（max） data type to store the message.
D.Use a check constraint to validate that the correct tags are used.
E.Use an XML schema definition （XSD） to validate that the correct tags are used.
F.Use a foreign key constraint to validate that the correct tags are used. -
单项选择题
Youneedtodesigntheretrievalofadvertisingstatisticswithoutcompromisingsecurity.Whatshouldyoudo?（）
A.Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.
B.Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.
C.Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.
D.Design a stored procedure to return the statistics on a call from the advertisers application.
E.Design a user-defined function to return the statistics on a call from the advertisers application. -
单项选择题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）
A.one that uses an internal SQL Server Web service endpoint
B.one that runs a SQL Server Integration Services （SSIS） package
C.one that uses Service Broker
D.one that runs a user-defined function
