The alarm will sound, and no, you won't need to unlock the phone to dismiss the alarm. It even comes with a snooze feature you can select if you want. It's my understanding the alarm will even ring if the phone is off, but I haven't tested this.
Posted from my CrackBerry at wapforums.crackberry.com