Depends on the programming language. :-)

Depends on what you mean by computer programming. Are you solving hard problems? Are you reasoning about them, or throwing things at the wall and seeing what sticks?

I would imagine computer programming does cause a mental fatigue, but your brain is very awake (unless you're just pulling the handle on the slop machine...)