Test: Quiz: Using SET Operators

Section 1

1. The difference between UNION and UNION ALL is Mark for Review
(1) Points


There is no difference between, you get exactly the same result.


UNION will remove duplicates, UNION ALL returns all rows from all queries (*)


UNION ALL is like a NATURAL JOIN


UNION is a synomym for UNION ALL






2. MINUS will give you rows from the first query not present in the second query? (True or False) Mark for Review
(1) Points


True (*)


False






3. INTERSECT will give you rows found in both queries? (True or False) Mark for Review
(1) Points


True (*)


False






4. Which ones of the following are correct SET operators? (choose two) Mark for Review
(1) Points

(Choose all correct answers)


UNION, MINUS (*)


UNION ALL, PLUS ALL


UNION ALL, INTERSECT (*)


MINUS, PLUS

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