Home » MCQs » Oracle MCQs

Oracle Inner, Outer, Equi, and Self Joins MCQs

Oracle Inner, Outer, Equi, and Self Joins MCQs: This section contains multiple-choice questions and answers on Inner, Outer, Equi, and Self Joins in Oracle.
Submitted by Anushree Goswami, on June 07, 2022

1. Most common type of Join is ____.

1. Inner
2. Outer
3. Anti
4. Equi

Answer: A) Inner

Explanation:

Most common type of Join is Inner Join.

Discuss this Question

---

2. All ____ from multiple tables matching the join condition are returned by the inner join.

1. Rows
2. Columns
3. Fields
4. None

Answer: A) Rows

Explanation:

All rows from multiple tables matching the join condition are returned by the inner join.

Discuss this Question

---

3. Similar to an ____ join, an outer join also matches rows that aren't matched in the table.

1. Equi
2. Inner
3. Anti
4. None

Answer: A) Equi

Explanation:

Similar to an equijoin, an outer join also matches rows that aren't matched in the table.

Discuss this Question

---

4. ____ Outer join returns all rows from the left (first) table that are specified by the ON condition, and all rows from the right table that are met by the join condition.

1. Left
2. Right
3. Middle
4. None

Answer: A) Left

Explanation:

This join returns all rows from the left (first) table that are specified by the ON condition and all rows from the right table that are met by the join condition.

Discuss this Question

---

5. In the Right Outer Join, all rows from the right-hand table specified by the ____ condition are returned along with only those from the left-hand table where the join condition is met.

1. ON
2. OFF
3. OK
4. AT

Answer: A) ON

Explanation:

In the Right Outer Join, all rows from the right-hand table specified by the ON condition are returned along with only those from the left-hand table where the join condition is met.

Discuss this Question

---

6. Outer joins return all rows from ____ tables.

1. First
2. Second
3. Both
4. None

Answer: C) Both

Explanation:

Outer joins return all rows from both tables.

Discuss this Question

---

7. ____ joins return the values of matching columns across associated tables.

1. Outer
2. Inner
3. Equi
4. None

Answer: C) Equi

Explanation:

Equi joins return the values of matching columns across associated tables.

Discuss this Question

---

8. An Equi Join refers to equality by using a comparison operator in the ____ clause.

1. FROM
2. HAVING
3. WHERE
4. None

Answer: C) WHERE

Explanation:

An Equi Join refers to equality by using a comparison operator in the WHERE clause.

Discuss this Question

---

9. Tables are joined with themselves (____ relationship) in Self Joins.

1. Unary
2. Binary
3. Ternary
4. None

Answer: A) Unary

Explanation:

Tables are joined with themselves (Unary relationship) in Self Joins.

Discuss this Question

---

10. Each row in a table is simply combined with every other row in the table when a ___ join is used.

1. Equi
2. Inner
3. Self
4. Outer

Answer: C) Self

Explanation:

Each row in a table is simply combined with every other row in the table when a self-join is used.

Discuss this Question

---

---