Chapter 7

12345678910111213
Across
  1. 3. a clause used to combine the output from multiple queries together into a single result table
  2. 6. a join that is the same as an equi-join except that one of the duplicate columns is eliminated in the result table
  3. 7. self joins are usually used with this relationship type
  4. 9. a subquery which does not depend on data from the outer query
  5. 12. a join in which rows that do not have matching values in common columns are nevertheless included in the result table
  6. 13. a joining table with itself
Down
  1. 1. creates a log file and starts recording all changes (insertions, deletions, and updates) to the database in this file(two words, no space)
  2. 2. this operator will return a TRUE value if the subquery resulted in a non-empty set, otherwise it returns a FALSE
  3. 4. a join clause is an alternative to WHERE clause, and is used to match primary and foreign keys
  4. 5. a subquery in which processing the inner query depends on data from the outer query
  5. 8. there should be one ON or ___ specification for each pair of tables being joined
  6. 10. a SQL keyword that acts as a IF-THEN-ELSE statement
  7. 11. a relational operation that causes two tables with a common domain to be combined into a single table or view