In Ubuntu, this depends on what settings you have chosen in Nautilus. In the
file manager, choose Edit/Preferences, and select the media tab. One check-box
is "Browse media when inserted," another is "Never prompt or start programs on
media insertion.

I *think* the Ubuntu 10.10 defaults are to browse and prompt.

Xubuntu? I have no idea.