How to create an SQlite database for a quiz?

Question

SQLite

Hi all.
The question is, you need to create a database in SQLite for a quiz.
There will be a question and 4 different answers.
How to implement it? Thank you.

Answer 1

The easiest option is to create a base with one table, which will have 7 columns:

1. id- question number;
   
2. text- question text;
   
3. answer1- the text of the first answer;
   
4. answer2- the text of the second answer;
   
5. answer3- the text of the third answer;
   
6. answer4- the text of the fourth answer;
   
7. right_answer- the number of the correct answer.