To create an indexed view, the base tables for the view must meet many criteria. The view then has additional restrictions. Some examples of these restrictions are as follows, which is Correct?
A.
The SELECT statement cannot reference other views.
B.
All functions must be deterministic. For example, you cannot use getdate() because every time it is executed, it returns a different date result.
C.
AVG, MIN, MAX, and STDEV are not allowed.