You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a common language runtime (CLR) user-defined scalar
function. The function will return an integer value. You need to ensure that the computed
columns that use the result from this function can be indexed. What should you do?

A.
D. 1.•Ensure that the logic of the function returns a different value for the same input
values and the same database state. 2. Ensure that the IsDeterministic property is set to
False.

B.
C. 1. Ensure that the logic of the function returns the same value for the same input
values and the same database state. 2. Ensure that the IsDeterministic property is set to
False.

C.
1. Ensure that the logic of the function returns the same value for the same input values
and the same database state. 2. Ensure that the IsDeterministic property is set to True.

D.
1·Ensure that the logic of the function returns a different value for the same input values
and the same database state. 2·Ensure that the IsDeterministic property is set to True.