Theta join is a type of join operation in Database Management Systems (DBMS) that combines tuples from two relations based on a condition. This condition can use any comparison operator, not just equivalence (e.g., =), unlike Equi joins.