I see a number of questions on this site with incorrect answers. The incorrect answers are the most up-voted ones and sometimes even accepted by the original posters. In all of these instances the 'top' answer is based on a common misconception about the database platform or SQL in general. In some instances people have written in the comments calling out the misconception, but the answer remains the top voted, accepted answer.
If they are not moderated it feels to me that this is a fundamental flaw in the system. Imagine if a site like this had existed when people still thought the sun revolved around the earth. The "Earth Revolves around the Sun" answer would have nothing but down-votes, while a "Sun Revolves Around the Earth" answer would be accepted.
So my question is, how is this mis-information moderated? Can the incorrect accepted answers be flagged or deleted? Do moderators make periodic passes?