Question

Syntax for creation of user defined function is ____________

(a) CREATE FUNCTIONS

(b) CREATE FUNCTION

(c) CREATE FUNC

(d) All of the mentioned

I got this question in an online quiz.

This is a very interesting question from User Defined Functions topic in section Developing with SQL Server of SQL Server

Answer 1

The correct answer is (b) CREATE FUNCTION

To explain: If a CREATE FUNCTION statement produces side effects against resources that do not exist when the CREATE FUNCTION statement is issued.