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. The relationships between tables are defined by what?

    a. Their query results

    b. The columns they have in common

    c. The number of rows they contain

    d. The number of columns they contain

  2. In an ANSI-compliant join, which clause creates the equivalence relationship needed to form a join?

    a. The SELECT clause

    b. The FROM clause

    c. The WHERE clause

    d. The HAVING clause

  3. Which of these is formed when every row of one table is joined to every row of another table?

    a. An intersecting product

    b. A union product

    c. A Cartesian product

    d. A truncated product

  4. Which of these joins is generally considered the least useful in real-world situations?

    a. A Cartesian join

    b. An equi join

    c. A natural join

    d. A multi-table join

  5. Given that two tables have 50 rows and ...

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