Notification sounds and text message sound (and testing sounds)
You can enable notification sounds for various events. To use your own sounds see this article.
Testing notification sounds
You can test the sounds by un-checking and checking the notification sounds. This should play this sound.