Oracle Database SQL — Question 103

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

Answer options

• A. Rows from unrelated tables cannot be joined.
• B. Relating data from a table with data from the same table is implemented with a self join.
• C. Implementing a relationship between two tables might require joining additional tables.
• D. Every relationship between the two tables must be implemented in a join condition.
• E. An inner join relates rows within the same table.

Correct answer: B, C

Explanation

Option B is correct because a self join is specifically used to relate data within the same table. Option C is also correct as establishing a relationship between two tables can sometimes necessitate the inclusion of additional tables. The other options either state incorrect facts or misinterpret the nature of joins and relationships.