It's all in what folders you put them in. Andybarilla is right, putting ringtones in /sdcard/media/ringtones will keep the music app from indexing them. Put your notifications in /sdcard/media/notifications and your alarms in /sdcard/media/alarms.
You'll have to create the folders yourself, android doesn't create them automatically.