What is the difference between situational, competency-based, and behavioral questions?

What is the difference between situational, competency-based, and behavioral questions? When would you use each type of question? When would you want to include all three types during an interview