Db design for a quiz with variable number of answer choices, and each worth different score in a different category?
Consider a data model like this:



You have a list of quesitons in the QUESTION table.  Each question can have two or more possible options for answers in the OPTION table.  For each option there are one or more category score changes which are noted in OPTION_CATEGORY.  When a USER takes the quiz their answers (i.e. choices of options) are recorded in ANSWER.

Note that with this design you can change someone's score in multiple categories with a single answer (such as in your example of reading WIRED magazine) and you also have the option of changing someone's score in a category by an increment other than 1 (as in your example of not having taken an art class).  You could even change someones score by more than 1, for example in your question 1 you could score +10 in the science category for prefering to read Philosophical Transactions of the Royal Society!