Microsoft
MB6-890 · Question #34
What is the effect of using an exists or notexists join clause between two tables in a select statement?
The correct answer is A. Only the first table is populated by using the join clause. See the full explanation below for the reasoning.
Question
What is the effect of using an exists or notexists join clause between two tables in a select statement?
Options
- AOnly the first table is populated by using the join clause.
- BOnly the second table is populated by using the join clause.
- CBoth tables are populated by using the join clause.
- DNeither table is populated by using the join clause.
How the community answered
(58 responses)- A81% (47)
- B2% (1)
- C12% (7)
- D5% (3)
Community Discussion
No community discussion yet for this question.