TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Create a function that returns a list of values that represent the login times for the given user.
B.
Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
C.
Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
D.
Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.
Explanation:
Values representing login times will only show at what time a user logs in not for how long and values representing users who have logged more hours than the current user has logged does not have to show activity time for all users.