The notification sound is played when new mail arrives.
There are more levels where notification sound may be configured:
So it is possible to fine-tune notification sound on various levels. Leaving the notification as default will use sound notification from upper level, until some non-default sound is found.
Valid sound notification setting is also Silent, which means that notification sound will not be played.