Question

Point out the wrong statement.

(a) You can create the function once, store it in the database

(b) CLR functions offer significant performance advantage over Transact-SQL functions for computational task

(c) Function is a database object in Sql Server

(d) None of the mentioned

I got this question during a job interview.

I would like to ask this question from User Defined Functions in section Developing with SQL Server of SQL Server

Answer 1

The correct choice is (d) None of the mentioned

To explain I would say: Function is a set of sql statements that accepts only input parameters, perform actions and return the result.