The term handheld microphone generally means any microphone that's supposed to be held in the hand while picking up sound. Handheld microphones are used in a huge variety of settings, from musical performances to television interviews.
Supercardioid microphones offer a narrower pickup than cardioids and a greater rejection of ambient sound. But they also have some pickup directly at the rear, hence it is important to place monitor speakers correctly. Supercardioids are most suitable when single sound sources need to be picked up in loud environments. They are very resistant to feedback.
Condenser microphones are more sensitive than Dynamic microphones. They use an electrically-charged diaphragm & backplate assembly to form a sound sensitive capacitor. When sound sets the diaphragm in motion, the distance between the diaphragm and the backplate changes. This variation in spacing changes the capacity of the capacitor, and produces the needed electrical signal. All condenser microphones need to be powered: either by batteries in the microphone or by externally provided phantom power.
A microphone with tailored frequency response is usually designed to enhance a sound source in a particular application. For instance, a microphone may have a peak in the 2 – 8 kHz range to increase intelligibility for live vocals.
3 Pin XLR: The circular 3-pin XLR connector is an industry standard for balanced audio signals.