nerdexam
Oracle

1Z0-202 · Question #65

View the Exhibit. On the Opportunity business component, what should the Join Specification look like when you are joining to the S_ORG_EXT table to access account information such as NAME?

The correct answer is E. Destination Column = PAR_ROW_ID and Source Field = Account Id. See the full explanation below for the reasoning.

Question

View the Exhibit. On the Opportunity business component, what should the Join Specification look like when you are joining to the S_ORG_EXT table to access account information such as NAME?

Exhibit

1Z0-202 question #65 exhibit

Options

  • AThere is no explicit Join or Join Specification.
  • BDestination Column = PAR_ROW_ID and Source Field = Id
  • CDestination Column = ROW_ID and Source Field = Id
  • DDestination Column = NAME and Source Field = Account Name
  • EDestination Column = PAR_ROW_ID and Source Field = Account Id

How the community answered

(61 responses)
  • A
    10% (6)
  • B
    3% (2)
  • C
    2% (1)
  • D
    2% (1)
  • E
    84% (51)

Community Discussion

No community discussion yet for this question.

Full 1Z0-202 Practice