Oracle SQL Joins and Set Operators

1. Which clause is used to specify join conditions in Oracle SQL?

ON

WHERE

USING

Both ON and USING

2. To join three or more tables, you can chain multiple JOIN clauses in a single SELECT statement.

True

False

3. Which set operator preserves duplicates without removing them?

UNION ALL

UNION

INTERSECT

MINUS

Submit

5. In a LEFT JOIN with NULL values in the join condition, unmatched rows from the left table still appear.

True

False

6. Set operators combine result sets from multiple queries. Which operator returns rows that appear in all queries?

INTERSECT

UNION

MINUS

UNION ALL

7. Which of the following is a valid join syntax in Oracle SQL?

SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

SELECT * FROM table1, table2 WHERE table1.id = table2.id

SELECT * FROM table1 JOIN table2 USING (id)

All of the above

Submit

9. When using set operators, both queries must have the same number of columns.

True

False

10. What is the key difference between UNION and UNION ALL?

UNION removes duplicates; UNION ALL keeps them

UNION ALL removes duplicates; UNION keeps them

UNION works with multiple tables; UNION ALL works with two

There is no difference

11. Which JOIN type returns only rows where both tables have matching values?

INNER JOIN

LEFT OUTER JOIN

FULL OUTER JOIN

CROSS JOIN

Submit

14. UNION ALL removes duplicate rows from the result set.

True

False

15. A FULL OUTER JOIN returns all rows from both tables with NULLs where no match exists.

True

False

16. What does the MINUS operator return?

Rows in first query but not in second query

Rows common to both queries

All rows from both queries

Rows in second query but not in first query

17. Which JOIN produces a Cartesian product of two tables?

CROSS JOIN

INNER JOIN

NATURAL JOIN

SELF JOIN

18. What is the result of INTERSECT between two result sets?

Rows that appear in both result sets

Rows that appear in either result set

Rows from first set minus rows in second set

All rows from both sets with duplicates

19. Which set operator removes duplicate rows and returns distinct rows from both queries?

UNION

UNION ALL

INTERSECT

MINUS

20. What does a LEFT OUTER JOIN return?

All rows from left table with matching rows from right table

Only matching rows from both tables

All rows from both tables

All rows from right table with matching rows from left table

Oracle SQL Associate Table Joins and Set Operators Quiz

1. Which clause is used to specify join conditions in Oracle SQL?

2.

What first name or nickname would you like us to use?

2. To join three or more tables, you can chain multiple JOIN clauses in a single SELECT statement.

3. Which set operator preserves duplicates without removing them?

4. The USING clause in a join specifies ____ that have the same name in both tables.

5. In a LEFT JOIN with NULL values in the join condition, unmatched rows from the left table still appear.

6. Set operators combine result sets from multiple queries. Which operator returns rows that appear in all queries?

7. Which of the following is a valid join syntax in Oracle SQL?

8. A RIGHT OUTER JOIN returns all rows from the ____ table plus matching rows from the left table.

9. When using set operators, both queries must have the same number of columns.

10. What is the key difference between UNION and UNION ALL?

11. Which JOIN type returns only rows where both tables have matching values?

12. A SELF JOIN is used to join a table to ____.

13. In a NATURAL JOIN, Oracle automatically joins tables on columns with the same ____.

14. UNION ALL removes duplicate rows from the result set.

15. A FULL OUTER JOIN returns all rows from both tables with NULLs where no match exists.

16. What does the MINUS operator return?

17. Which JOIN produces a Cartesian product of two tables?

18. What is the result of INTERSECT between two result sets?

19. Which set operator removes duplicate rows and returns distinct rows from both queries?

20. What does a LEFT OUTER JOIN return?