Posted by: Pdfprep
Post Date: November 25, 2020
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
Leave a Reply