Comtek Services interview question

What is Oops ? How many Types Of Joins In Sql ?