PdfPrep.com

What type of function is created using the following command?

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)
A . Row
B . Table
C . Scalar
D . External

Answer: C

Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/

db2z_sql_createfuncinlinesqlscalar.html

Exit mobile version