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 ____.
- Inner
- Outer
- Anti
- 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.
- Rows
- Columns
- Fields
- 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.
- Equi
- Inner
- Anti
- 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.
- Left
- Right
- Middle
- 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.
- ON
- OFF
- OK
- 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.
- First
- Second
- Both
- 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.
- Outer
- Inner
- Equi
- 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.
- FROM
- HAVING
- WHERE
- 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.
- Unary
- Binary
- Ternary
- 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.
- Equi
- Inner
- Self
- 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