nerdexam
Oracle

1Z0-074 · Question #61

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

The correct answer is A. Implementing a relationship between two tables might require joining additional tables E. An inner join relates rows within the same table. See the full explanation below for the reasoning.

Question

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

Options

  • AImplementing a relationship between two tables might require joining additional tables
  • BRelating data from a table with data from the same table is implemented with a self join
  • CRows from unrelated tables cannot be joined
  • DEvery relationship between the two tables must be implemented in a join condition
  • EAn inner join relates rows within the same table

How the community answered

(45 responses)
  • A
    78% (35)
  • B
    4% (2)
  • C
    11% (5)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice