Which of the following can be used as basic approaches for joining tables?
2023
Which of the following can be used as basic approaches for joining tables?
- A.
Union JOIN
- B.
Natural JOIN
- C.
Subqueries
- D.
More than one of the above
- E.
None of the above
Attempted by 1836 students.
Show answer & explanation
Correct answer: D
Correct answer: More than one of the above
In DBMS/SQL MCQ terminology, more than one listed method can be used to combine data from related tables. Natural JOIN is a direct join operation, and subqueries can also be used to retrieve related table data. Some source classifications also include Union JOIN under table-combination approaches.
Natural JOIN: directly combines tables using common attribute names.
Subqueries: can be used as an alternate way to combine or filter data using another table.
Therefore: more than one listed approach applies, so the single Natural JOIN key was too narrow.
Final answer: More than one of the above.