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.
- SELF
- INNER
- OUTER
- 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.
- X+Y
- X*Y
- X/Y
- 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.
- Analytical
- Relational
- Cartesian
- 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.
- Slows
- Speeds
- Break
- 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.
- Equi
- Anti
- Cross
- 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 ____.
- Cross Join
- Anti Join
- Inner Join
- 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.
- Cross
- Semi
- Anti
- 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.
- NOT EXISTS
- NOT IN
- Both A and B
- 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.
- WHERE IS
- WHERE TO
- WHERE FOR
- 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.
- Self
- Semi
- Anti
- 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.
- AT
- FOR
- NOR
- 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.
- Semi
- Anti
- Cross
- 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