How common are night terrors as a child?

Fairly common. Night terrors are common deep sleep phenomena that are developmentally normal and can occur between 1-3 years of age.