It's Open ID which allows you to use a single ID for multiple sites. If you use a Google password with StackOverflow then Stackoverflow gets confirmation from Google that you are who you say you are. Your password is not seen by Stackoverflow.

At least that's the theory. I have no idea how far you can trust that assertion.