70-761 Exam Dumps | You have a database named MyDb. You run the following Transact-SQL statements: (Exhibit) A value of 1

Valid 70-761 Dumps shared by ExamDiscuss.com for Helping Passing 70-761 Exam! ExamDiscuss.com now offer the newest 70-761 exam dumps, the ExamDiscuss.com 70-761 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-761 dumps with Test Engine here:

Access 70-761 Dumps Premium Version
(205 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 9/71

You have a database named MyDb. You run the following Transact-SQL statements:

A value of 1 in the IsActive column indicates that a user is active.
You need to create a count for active users in each role. If a role has no active users. You must display a zero as the active users count.
Which Transact-SQL statement should you run?

A. SELECT R.RoleName, COUNT(*) AS ActiveUserCount FROM tblRoles RCROSS JOIN (SELECT UserId, RoleId FROM tblUsers WHERE IsActive = 1) UWHERE U.RoleId = R.RoleIdGROUP BY

B. SELECT R.RoleName, U.ActiveUserCount FROM tblRoles R CROSS JOIN(SELECT RoleId, COUNT (*) AS ActiveUserCountFROM tblUsers WHERE IsActive = 1 GROUP BY R.RoleId) U

C. SELECT R.RoleName, ISNULL (U.ActiveUserCount,0) AS ActiveUserCountFROM tblRoles R LEFT JOIN (SELECT RoleId, COUNT(*) AS ActiveUserCountFROM tblUsers WHERE IsActive = 1 GROUP BY R.RoleId) U

D. RoleName

E. RoleId, R.RoleName

F. SELECTR.RoleName, COUNT(*) AS ActiveUserCount FROM tblRoles RLEFT JOIN (SELECT UserId, RoleId FROM tblUsers WHERE IsActive = 1) UON U.RoleId = R.RoleIdGROUP BY R.RoleId,

Question 9/71

LEAVE A REPLY

Download PDF File