Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 13, "Joining Tables in Queries"

Quiz Answers

1:	What type of join would you use to return records from one table, regardless of the existence of associated records in the related table?
A1:	You would use an OUTER JOIN.
2:	The join conditions are located in what part of the SQL statement?
A2:	The JOIN conditions are located in the WHERE clause.
3:	What type of join do you use to evaluate equality among rows of related tables?
A3:	You would use an EQUIJOIN.
4:	What happens if you select from two different tables but fail to join the tables?
A4:	You receive a Cartesian Product by not joining the tables (this is also called a cross join).
5:	Use the following tables: ORDERS_TBL       ORD_NUM VARCHAR2(10) NOT NULL PRIMARY KEY CUST_ID VARCHAR2(10) NOT NULL   PROD_ID ...