Domain.com has employed you as a database administrator. Your duties at Domain.com encompass administrating a SQL Server computer named Certkiller -DB03.
You have received instruction from the CIO to retrieve data concerning a user who is currently logged in on the system. You create a function that returns scalar information about the activity time for a particular user.
How can you accomplish this goal? (Choose all that apply)
A.
You should create a function that will return a numeric value which will signify the number of hours that particular user has logged for the current day.
B.
You should create a function that returns a numeric value that represents the number of hours a user has logged for the current month.
C.
You should create a function that returns a list of values that represent the login times for the given user in order for you to receive this information
D.
You should create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
Explanation:
The 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.