Which database function is used to combine related records from two or more tables?

Options

  • A. Sorting
  • B. Joining
  • C. Indexing
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Joining

Detailed Explanation

  • Joining: Combines rows from two or more tables using related columns.
  • Common types include INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN.
  • Joins help retrieve related information stored in separate tables.