Quiz: Nonequijoins

Test: Quiz: Nonequijoins
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1

1. Which statement about joining tables with a non-equijoin is false? Mark for Review
(1) Points


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



Correct Correct


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
WHERE e.salary
BETWEEN j.lowest_sal AND j.highest_sal;

True or False?
Mark for Review
(1) Points


True (*)


False



Correct Correct


3. Which of the following operators is/are typically used in a nonequijoin? Mark for Review
(1) Points


NOT


OR


IN


>=, <=, BETWEEN ...AND (*)


*



Correct Correct


Page 1 of 1 Summary


( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )