MCQ King
Oracle – Inner and Outer joins
1 / 25
1. What is the result of an INNER JOIN in Oracle SQL?
2 / 25
2. Which type of join returns all rows from both tables in Oracle SQL?
3 / 25
3. In Oracle SQL, what is the purpose of an OUTER JOIN?
4 / 25
4. What is the primary difference between INNER JOIN and OUTER JOIN in Oracle SQL?
5 / 25
5. Which keyword is used to perform an INNER JOIN in Oracle SQL?
6 / 25
6. What is the result of a LEFT JOIN in Oracle SQL?
7 / 25
7. Which type of join returns all rows from the left table and the matching rows from the right table in Oracle SQL?
8 / 25
8. In Oracle SQL, which clause is used to specify the condition for joining tables in a JOIN operation?
9 / 25
9. What is the outcome of a RIGHT JOIN in Oracle SQL?
10 / 25
10. Which type of join returns all rows from both tables along with NULL values in case of no match in Oracle SQL?
11 / 25
11. In Oracle SQL, what does the ON clause specify in a JOIN operation?
12 / 25
12. Which keyword is used to perform a RIGHT JOIN in Oracle SQL?
13 / 25
13. What is the result of a FULL OUTER JOIN in Oracle SQL?
14 / 25
14. In Oracle SQL, what does an OUTER JOIN return when there is no match for a row in one of the tables?
15 / 25
15. Which type of join returns only rows that exist in both tables in Oracle SQL?
16 / 25
16. What is the primary purpose of using a JOIN in Oracle SQL?
17 / 25
17. In Oracle SQL, which type of JOIN should be used to return rows that exist in both tables and NULL values for non-matching rows?
18 / 25
18. What is the outcome of a LEFT JOIN in Oracle SQL?
19 / 25
19. Which keyword is used to perform a FULL OUTER JOIN in Oracle SQL?
20 / 25
20. What is the primary difference between a LEFT JOIN and a RIGHT JOIN in Oracle SQL?
21 / 25
21. In Oracle SQL, what does an INNER JOIN return when there is no match for a row in one of the tables?
22 / 25
22. Which type of join returns all rows from the right table and the matching rows from the left table in Oracle SQL?
23 / 25
23. What is the primary purpose of an OUTER JOIN in Oracle SQL?
24 / 25
24. Which keyword is used to perform a LEFT JOIN in Oracle SQL?
25 / 25
25. What does a FULL OUTER JOIN return when there are no matching rows between two tables in Oracle SQL?
Your score is
Restart quiz