Test: Quiz: Nonequijoins
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1. Which statement about joining tables with a non-equijoin is false? Mark for Review
A WHERE clause must specify a column in one table that is compared to a column in the second table (*)
The number of join conditions required is always one less than the number of tables being joined
The columns being joined must have compatible data types
None of the above
2. The following statement is an example of a nonequi-join?
SELECT e.last_name, e.salary, j.grade_level
FROM employees e, job_grades j
BETWEEN j.lowest_sal AND j.highest_sal;
True or False?
Mark for Review
3. Which of the following operators is/are typically used in a nonequijoin? Mark for Review
>=, <=, BETWEEN ...AND (*) *