多项选择题

You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）

A.Create a database role named BankTerminals.
B.Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
C.Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
D.Grant the BankTerminals role the Execute permission for the Bank schema.
E.Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
F.Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.

<上一题目录下一题>

热门试题

多项选择题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.

多项选择题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

多项选择题YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform?（）

A.Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
B.Ensure that the stored procedure and the tables are owned by the same database user.
C.Ensure that the stored procedure and the tables use the same database schema.
D.Configure the multiuser database option on both databases.
E.Configure the cross-database ownership chaining option on both databases.