Home »
MCQs »
Oracle MCQs
Oracle Joins MCQs
Oracle Joins MCQs: This section contains multiple-choice questions and answers on Joins in Oracle.
Submitted by Anushree Goswami, on June 07, 2022
1. When you join two or more tables, views, or materialized views, you combine ____ from both tables, views, or materialized views.
- Rows
- Columns
- Both A and B
- None of the above
Answer: A) Rows
Explanation:
When you join two or more tables, views, or materialized views, you combine rows from both tables, views, or materialized views.
Discuss this Question
2. Oracle Joins _____ data from multiple tables into one.
- Retrieve
- Combine
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Oracle Joins retrieve and combine data from multiple tables into one.
Discuss this Question
3. The ____ clause must contain a join condition for joining two tables.
- FROM
- WHERE
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The FROM clause and the WHERE clause must contain a join condition for joining two tables.
Discuss this Question
4. The program compares two columns from different tables and combines pairs of rows containing the same row from both tables, provided that the ____ condition holds.
- Join
- Minus
- Non-Join
- Addition
Answer: A) Join
Explanation:
The program compares two columns from different tables and combines pairs of rows containing the same row from both tables, provided that the join condition holds.
Discuss this Question
5. How many types of Joins are there?
- 5
- 6
- 7
- 8
Answer: C) 7
Explanation:
There are 7 types of joins.
Discuss this Question
6. Which of the following is/are the type(s) of joins?
- Inner
- Outer
- Equi
- All of the above
Answer: D) All of the above
Explanation:
The following are the types of Joins - Inner, Outer, Equi, etc.
Discuss this Question
7. How many types of Outer Joins are there?
- 3
- 4
- 5
- 6
Answer: A) 3
Explanation:
There are 3 types of Outer Joins.
Discuss this Question
8. Which of the following is/are the type(s) of Outer Join?
- Left Outer Join
- Right Outer Join
- Full Outer Join
- All of the above
Answer: D) All of the above
Explanation:
The following are the types of Outer Join - Left Outer, Right Outer, Full Outer Join.
Discuss this Question
9. Which of the following is not the type of Join?
- Cross Join
- Anti Join
- Semi Join
- None
Answer: D) None
Explanation:
All of the above are types of Joins.
Discuss this Question
10. What is another name for Inner Join?
- Simple Join
- Natural Join
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Another name for Inner Join are Simple Join and Natural Join.
Discuss this Question
11. What is another name for Cross Join?
- Left Join
- Right Join
- Full Join
- Cartesian Products
Answer: D) Cartesian Products
Explanation:
Another name for Cross Join is Cartesian Product.
Discuss this Question