Super-Volcanoes

A recent study found that the eruption of a so-called "super-volcano" is hundreds of times more powerful a than conventional volcanic eruption. What are "super-volcanoes" and where are they found? What consequences could the eruption of one of these super-volcanoes have for the populations nearby?