HOTSPOT
You have a database that contains the following tables: tblRoles, tblUsers, and tblUsersInRoles.
The table tblRoles is defined as follows.
You have a function named ufnGetRoleActiveUsers that was created by running the following Transact-SQL
statement:
You need to list all roles and their corresponding active users. The query must return the RoleId, RoleName,
and UserName columns. If a role has no active users, a NULL value should be returned as the UserName for
that role.How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL
segments in the answer area.
Hot Area:
Answer: 
Correct