What sorts of problems can turn the check engine light on? In particular, can a misfiring plug turn the light on?

If the problem that turned the light on is fixed, will the light go out, or does something have to be reset manually to make it go out?

Thanks for any help