You need to create a clustered index on a view. Which functions can be used inside the view definition?

You need to create a clustered index on a view. Which functions can be used inside the view definition?

You need to create a clustered index on a view. Which functions can be used inside the view definition?


A – AVG( )
C – RAND( )

(You need to use only deterministic functions. RAND is deterministic only when a seed is specified, and GETDATE is nondeterministic. The reason a. and c. are correct is because AVG( ) and RAND(1000) are deterministic.)