Quiz

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




  11. This was first published in February 2006

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: