Chapter 7

3. a clause used to combine the output from multiple queries together into a single result table
6. a join that is the same as an equi-join except that one of the duplicate columns is eliminated in the result table
7. self joins are usually used with this relationship type
9. a subquery which does not depend on data from the outer query
12. a join in which rows that do not have matching values in common columns are nevertheless included in the result table
13. a joining table with itself

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. this operator will return a TRUE value if the subquery resulted in a non-empty set, otherwise it returns a FALSE
4. a join clause is an alternative to WHERE clause, and is used to match primary and foreign keys
5. a subquery in which processing the inner query depends on data from the outer query
8. there should be one ON or ___ specification for each pair of tables being joined
10. a SQL keyword that acts as a IF-THEN-ELSE statement
11. a relational operation that causes two tables with a common domain to be combined into a single table or view