Will the local notification show up when the app is in foreground and currently running in iPhone SDK?
No, you will receive a the notification in the appdelegate.
- (void) application:(UIApplication *)application didReceiveLocalNotification: (UILocalNotification *)notification {
//Place your code to handle the notification here.
}