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

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