IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 35

What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)

RETURNS DOUBLE -

LANGUAGE SQL -

CONTAINS SQL -

NO EXTERNAL ACTION -

DETERMINISTIC -
RETURN SIN(X)/COS(X)

Answer options

Correct answer:

Explanation

The function defined in the command returns a single value based on the input, which classifies it as a Scalar function. Row and Table functions return multiple rows or tables, and External C functions are written in C, which does not apply here.