IBM DB2 9 Fundamentals certification exam answer key
The correct answers are A and B: -- VALUES degf_to_c(32) and SELECT date, degf_to_c(temp) AS temp_c FROM temp_data.
How a user-defined function is invoked depends a lot on what it has been designed to do; scalar user-defined functions can be invoked as an expression in the select list of a query while table and row functions must be referenced by the FROM clause.
Because theuser-defined function used in this example is a scalar function that only returns a single value...
• To read the rest of this question's explanation, and to practice with more sample questions from the IBM DB2 9 Fundamentals exam, (Exam 730), purchase the book at MC Press.
• Go back to the list of sample exam questions.
This was first published in September 2007