# 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

Explanation:

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

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

Explanation:

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

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

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

Explanation:

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

4. Anti-join ____ up queries.

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

Explanation:

Anti-join speeds up queries.

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

Explanation:

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

6. Semi-Join is the opposite of ____.

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

Explanation:

Semi-Join is the opposite of Anti Join.

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

Explanation:

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

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.

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

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

Explanation:

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

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

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.

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

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

Explanation:

The EXISTS construct is used to write semi-joins.

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

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.