未分类题

You are adatabase developer.You develop ataskmanagementapplication that connect stoa SQLServer2008databasenamed TaskDB.Users logon to the application by using a SQLServer login. The application containsamodulenamed Taskthatassignstaskstousers.Informationaboutthe setasksisstoredinthe Taskstableofthe TaskDB data base.The Taskstablecontainsmultiplecolumns.These include the Close Dateand Estimated Timecolumns.Theapplication mustmeetthefollowingsecurityrequirements:Usersassigned toad atabase role named User 1 canupd ate all taskinformation columnsexceptthe Close Dateandthe Estimated TimecolumnsintheTaskstable.Administrative usersassigned toad atabase rolenamed Task_Admincanupd ateall taskinformation intheTaskstable.Youneedtodesignastrategy tomeetthesecurityrequirements.
Whichtwoactionsshouldyouperform?()

A.You
B.Users
C.Informationaboutthe
D.The
E.These
F.Theapplication
G.Administrative
H.Youneedtodesignastrategy
I.

【参考答案】

B, C