Home » MCQs » Oracle MCQs

Oracle Cross, Anti, and Semi Joins MCQs

Oracle Cross, Anti, and Semi Joins MCQs: This section contains multiple-choice questions and answers on Cross, Anti, and Semi Joins in Oracle.
Submitted by Anushree Goswami, on June 08, 2022

1. All rows from the first table will join with all of the rows from the second table in a ____ JOIN.

1. SELF
2. INNER
3. OUTER
4. CROSS

Answer: D) CROSS

Explanation:

All rows from the first table will join with all of the rows from the second table in a CROSS JOIN.

Discuss this Question

---

2. A cross join has ____ rows when table1 and table2 have "x" rows and "y" rows, respectively.

1. X+Y
2. X*Y
3. X/Y
4. X-Y

Answer: B) X*Y

Explanation:

A cross join has X*Y rows when table1 and table2 have "Y" rows and "Y" rows, respectively.

Discuss this Question

---

3. If two tables are not joined in a query, Oracle will return their ____ product.

1. Analytical
2. Relational
3. Cartesian
4. None

Answer: C) Cartesian

Explanation:

If two tables are not joined in a query, Oracle will return their Cartesian product.

Discuss this Question

---

4. Anti-join ____ up queries.

1. Slows
2. Speeds
3. Break
4. None

Answer: B) Speeds

Explanation:

Anti-join speeds up queries.

Discuss this Question

---

5. When two tables are ____ joined, no rows are returned from the first table if the second table has no matches.

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

Answer: B) Anti

Explanation:

When two tables are anti-joined, no rows are returned from the first table if the second table has no matches.

Discuss this Question

---

6. Semi-Join is the opposite of ____.

1. Cross Join
2. Anti Join
3. Inner Join
4. Outer Join

Answer: B) Anti Join

Explanation:

Semi-Join is the opposite of Anti Join.

Discuss this Question

---

7. If no match is found for a row in the first table, then an ___-join returns a copy of each row.

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

Answer: C) Anti

Explanation:

If no match is found for a row in the first table, then an anti-join returns a copy of each row.

Discuss this Question

---

8. ____ is/are used for anti-joins.

1. NOT EXISTS
2. NOT IN
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

NOT EXISTS and NOT IN are used for anti-joins.

Discuss this Question

---

9. A ____ subquery can be efficiently performed by using a Semijoin.

1. WHERE IS
2. WHERE TO
3. WHERE FOR
4. WHERE EXISTS

Answer: D) WHERE EXISTS

Explanation:

A WHERE EXISTS subquery can be efficiently performed by using a Semijoin.

Discuss this Question

---

10. When a ____-join is applied, one copy of every row in the first table with at least one matching row will be returned.

1. Self
2. Semi
3. Anti
4. Outer

Answer: B) Semi

Explanation:

When a semi-join is applied, one copy of every row in the first table with at least one matching row will be returned.

Discuss this Question

---

11. The ____ construct is used to write semi-joins.

1. AT
2. FOR
3. NOR
4. EXISTS

Answer: D) EXISTS

Explanation:

The EXISTS construct is used to write semi-joins.

Discuss this Question

---

12. In contrast to a ____-join, an anti-join returns one copy of each row in the first table in which a match is found, but no matches are found in the ____-join.

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

Answer: A) Semi

Explanation:

In contrast to a semi-join, an anti-join returns one copy of each row in the first table in which a match is found, but no matches are found in the semi-join.

Discuss this Question

---

---