You can choose a default sound for your phone to play whenever there are new notifications.
To use different sounds for different types of notifications, set the notification sounds in the respective applications. For example, to set different sounds for received and sent text messages, open Messages, then press MENU and tap Settings.