It gives it the same setting as if you set it on the iPhone....which in my case is just "Message" but not "Message with Sound".
Now on the iPhone, all Calendar alerts come with a message and sound.
So yeah, it's basically like you added it on the iPhone.