Know-IT-All Chapter Quiz: SQL Built-In Functions

Think you know all there is about built-in functions? We challenge you to test your skills by taking our latest quiz.

Think you know all there is about built-in functions? We challenge you to test your skills by taking our latest quiz. All answers to this quiz are found in the free excerpt. Let us know how you did.
Good luck!

  1. The SQL BIFs in DB2 can be broken down into ___________ main categories.
    a. one
    b. two
    c. three

    Your answer:

    See book excerpt, page 18, for answer

  2. This function returns the total of the supplied field values within the defined data set. What is it?
    a. Total
    b. Complete
    c. SUM

    Your answer:

    See book excerpt, page 18, for answer

  3. The COUNT function can be used to count the number of ________ in a group of records within a data set.
    a. columns
    b. rows
    c. queries

    Your answer:

    See book excerpt, page 20, for answer

  4. The COUNT function can only return a value of up to 15 digits. How many digits can the COUNT_BIG function support?
    a. 35
    b. 31
    c. 29

    Your answer:

    See book excerpt, page 20, for answer


  5. Scalar functions allow you to extend existing values within a ___________.
    a. data set
    b. sum set
    c. clause

    Your answer:

    See book excerpt, page 21, for answer

  6. The ABS function returns the ____________ value of the provided field or value.
    a. total
    b. negative
    c. absolute


    Your answer:

    See book excerpt, page 24, for answer

  7. Which function calculates the arc sine of a given number?
    a. SIN
    b. ASIN
    c. DECIMAL

    Your answer:

    See book excerpt, page 25, for answer

  8. The ATAN function calculates the arc tangent of the provided value. What is the opposite of the ATAN function?
    a. ATANH
    b. TAN
    c. TANH

    Your answer:

    See book excerpt, page 26, for answer

  9. The INTEGER and INT functions behave identically.
    a. True
    b. False

    Your answer:

    See book excerpt, page 26, for answer

  10. The DOUBLE, DOUBLE_PRECISION, and FLOAT functions convert the provided value into a floating point numeric value.
    a. True
    b. False

    Your answer:

    See book excerpt, page 99, for answer




This was first published in February 2006

Dig deeper on iSeries SQL commands and statements

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:

SearchEnterpriseLinux

SearchDataCenter

Close