Alpha waves (8-13 Hz) are predominantly present when a person is awake but in a relaxed, resting state with eyes closed. During deep sleep, the brain shows slower delta and theta waves. Being awake and nervous produces beta waves, while unconscious states show different wave patterns.