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.

1. Rows
2. Columns
3. Both A and B
4. 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.

1. Retrieve
2. Combine
3. Both A and B
4. 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.

1. FROM
2. WHERE
3. Both A and B
4. 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.

1. Join
2. Minus
3. Non-Join
4. 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?

1. 5
2. 6
3. 7
4. 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?

1. Inner
2. Outer
3. Equi
4. 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?

1. 3
2. 4
3. 5
4. 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?

1. Left Outer Join
2. Right Outer Join
3. Full Outer Join
4. 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?

1. Cross Join
2. Anti Join
3. Semi Join
4. None

Answer: D) None

Explanation:

All of the above are types of Joins.

Discuss this Question

---

10. What is another name for Inner Join?

1. Simple Join
2. Natural Join
3. Both A and B
4. 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?

1. Left Join
2. Right Join
3. Full Join
4. Cartesian Products

Answer: D) Cartesian Products

Explanation:

Another name for Cross Join is Cartesian Product.

Discuss this Question

---

---