There's an annual contest for spam community. It's organized by Botmaster, the producent of Xrumer software.
Basically, whoever answers most of these questions correctly, earns $15,000. People submit MILLIONS of answers.
This list is then incorporated into the Xrumer itself.
I can tell you that these things are easily broken:
a) Answering questions and building global list of answers, as in this case.
b) Reading image captcha - spammers send it to Pakistani manual solvers for dirt cheap.
c) More complex puzzle captchas can also be broken in software if a lot of websites implement them.
What works the best is using non standard html form field names. Also, try to not use text labels for the fields ( no "password", "captcha" etc. ) - because the software will try to match the best field by text surrounding it. It is better to use image for labels.
This solution will stop spambots because they simply match form field names. Unless someone specifically targets your website, in which case there's not much you can do.
From the most common of captchas, Mollom seemed to be the biggest pain in the ass for spammers. Mainly because it banned suspicious IPs ( you could solve the picture correctly and it wouldn't authorize it. )