You work as a database administrator at Domain.com. 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 Certkiller -DB03. You create a function that returns scalar information about the activity time for a particular user.
What should you do? (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.
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.