單項(xiàng)選擇題
【單選題】作為一家公司的軟件開發(fā)員，你正在創(chuàng)建一個(gè)ASP.NET應(yīng)用程序，采用基于角色的安全性來允許用戶訪問那些他們有權(quán)訪問的頁面。你用Microsoft SQL Server數(shù)據(jù)庫來管理用戶和角色的列表。Roles表有RoleID和RoleName兩列。表Users有UserID，UserName和Password三列。UserRoles表有UserID和RoleID。你需要?jiǎng)?chuàng)建一個(gè)存儲(chǔ)過程來返回屬于某特定的角色的所有用戶，你寫了如下的SQL存儲(chǔ)過程： CREATE PROCEDURE GetRoleMembers @RoleID int AS 采用哪個(gè)代碼段來完成此存儲(chǔ)過程？
A、SELECT UserRoles.UserID, Users.UserName FROM Users INNER JOIN Roles UserRoles On UserRoles.RoleID = Users.UserID WHERE UserRoles.RoleID = @RoleID
B、SELECT UserRoles.UserID, Users.UserName FROM UserRoles INNER JOIN Roles On UserRoles.RoleID = Roles.RoleID, Users WHERE UserRoles.RoleID = @RoleID
C、SELECT UserRoles.UserID, Users.UserName FROM UserRoles INNER JOIN Users On Users.UserID = UserRoles.UserID WHERE UserRoles.RoleID = @RoleID
D、SELECT Users.UserID. Users.UserName FROM Users, UserRoles INNER JOIN Roles On UserRoles.RoleID = Roles.RoleID WHERE UserRoles.RoleID = @RoleID
A.NET應(yīng)用程序，采用基于角色的安全性來允許用戶訪問那些他們有權(quán)訪問的頁面。你用Microsoft
B.UserID,
C.UserName
D.RoleID
E.UserID
F.RoleID
G.UserID,
H.UserName
I.RoleID
J.RoleID,
K.RoleID
L.UserID,
M.UserName
N.UserID
O.UserID
P.RoleID
Q.UserID.
R.UserName
S.RoleID
T.RoleID
U.RoleID
