Your company 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.