Oracle
1Z0-202 · Question #63
You are adding a Join and Join Specification to the Service Request business component to allow the ASSET_NUM column from the S_ASSET table to be displayed. You set the Outer Join Flag to TRUE…
See the full explanation below for the reasoning.
Question
You are adding a Join and Join Specification to the Service Request business component to allow the ASSET_NUM column from the S_ASSET table to be displayed. You set the Outer Join Flag to TRUE. Which two will be true? (Choose two.)
Options
- ANo ASSET_NUM values will be NULL.
- BSome ASSET_NUM values may be NULL.
- CAll rows in the S_ASSET table will be returned.
- DAll rows in the S_SRV_REQ table will be returned.
- EOnly rows in the S_SRV_REQ table that have matching rows in the S_ASSET table will be returned.
Community Discussion
No community discussion yet for this question.