Show of Hands

Within the constitution of seven states (in comments), there is some form of the following on record: "No person who denies the existence of a Supreme Being shall hold any office in this state." Are these on-the-books restrictions acceptable?