Yes it is possible, but they use undocumented enum values, that means you should not use it on AppStore apps.
AudioServicesPlaySystemSound(1003);
iOS SDK does not bundle these sound files, but you can find them on the device in the /System/Library/Audio/UISounds/ folder. However, I believe these files are copyrighted.