IBM DB2 9 Fundamentals certification (Exam 730): Answer key No. 6

Get the answer and a detailed explanation to a sample question from the IBM DB2 9 Fundamentals certification exam (Exam 730) study guide.

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

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close