PrepAway - Latest Free Exam Questions & Answers

What are two possible ways to achieve this goal?

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.)

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply