Sounds like you have a table for questions, a table for answers where the question id is paired with the answer record. Then you need a junction table to relate the examinee id and the ids of the questions asked (or an exam details table with a record for each question chosen). You can link this table to the answers table and get only the answers to the questions asked.
BTW, if you really have a field for each question or answer as you indicated, that design is wrong. It is not properly normalized.
Last edited by Micron; 06-24-2020 at 09:29 AM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.