O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Test your knowledge

  1. Which of these statements describes the process of taking data and performing the necessary operations to transform it into a form that is relevant to solving problems?

    a. Data aggregation

    b. Data analysis

    c. Data subjugation

    d. Data elimination

  2. The types of functions used in grouping data are called?

    a. Single-row functions

    b. Multi-row functions

    c. Restrictive functions

    d. Variance functions

  3. Which of these statements describes how an aggregate function works?

    a. The function takes a single value and returns a single value

    b. The function takes a single value and returns multiple values

    c. The function takes multiple values and returns a single value

    d. The function takes multiple values and returns multiple values

  4. Which of the following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required