Oracle
1Z0-202 · Question #62
You are adding a Join and Join Specification to the Service Request business component to access data in the S_ASSET table. You set the Outer Join Flag to FALSE, the Destination Column to ROW_ID and…
The correct answer is A. No rows will be returned. See the full explanation below for the reasoning.
Question
You are adding a Join and Join Specification to the Service Request business component to access data in the S_ASSET table. You set the Outer Join Flag to FALSE, the Destination Column to ROW_ID and the Source Field to ID . What will the result be?
Options
- ANo rows will be returned.
- BYou will get an SQL error.
- CThe implicit join will override this join.
- DAll rows in the S_SRV_REQ will be returned.
- EAll rows in the S_ASSET table will be returned.
How the community answered
(17 responses)- A71% (12)
- B18% (3)
- D6% (1)
- E6% (1)
Community Discussion
No community discussion yet for this question.