If your alarm clock application uses the alarm functionality built into Maemo, then your tablet will actually wake up from even an "off" state to sound an alarm.