Study guide

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

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...

    Requires Free Membership to View

•             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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: