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

Solution for Test: Quiz: Introduction to The Oracle Academy
Solution for Test: Quiz: Data vs Information
Top