MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

--
--  SOLUTION 2
--

CREATE TABLE question
(
  question_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  question_text VARCHAR (30) NOT NULL
);

INSERT INTO question (question_text) VALUES ('question_1_txt');
INSERT INTO question (question_text) VALUES ('question_2_txt');
INSERT INTO question (question_text) VALUES ('question_3_txt');
INSERT INTO question (question_text) VALUES ('question_4_txt');
INSERT INTO question (question_text) VALUES ('question_5_txt');
INSERT INTO question (question_text) VALUES ('question_6_txt');
INSERT INTO question (question_text) VALUES ('question_7_txt');
INSERT INTO question (question_text) VALUES ('question_8_txt');

CREATE TABLE student
(
  student_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  student_name VARCHAR (50) NOT NULL,
  UNIQUE (student_name)
);

INSERT INTO student (student_name) VALUES ('student_1');
INSERT INTO student (student_name) VALUES ('student_2');
INSERT INTO student (student_name) VALUES ('student_3');
INSERT INTO student (student_name) VALUES ('student_4');
INSERT INTO student (student_name) VALUES ('student_5');
INSERT INTO student (student_name) VALUES ('student_6');

CREATE TABLE test
(
  test_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  s_id INTEGER NOT NULL,
  q_id INTEGER NOT NULL
);

INSERT INTO test (s_id, q_id) 
SELECT * FROM (
SELECT s.student_id, tab1.question_id
FROM student s
CROSS JOIN (SELECT q2.question_id FROM question q2)
AS tab1) AS tab2 
ORDER BY student_id, question_id;

student_id	student_name	question_id	question_text
1	student_1	3	question_3_txt
1	student_1	1	question_1_txt
1	student_1	4	question_4_txt
1	student_1	2	question_2_txt
1	student_1	6	question_6_txt
1	student_1	7	question_7_txt
1	student_1	5	question_5_txt
1	student_1	8	question_8_txt
2	student_2	8	question_8_txt
2	student_2	5	question_5_txt
2	student_2	3	question_3_txt
2	student_2	2	question_2_txt
2	student_2	4	question_4_txt
2	student_2	7	question_7_txt
2	student_2	1	question_1_txt
2	student_2	6	question_6_txt
3	student_3	6	question_6_txt
3	student_3	4	question_4_txt
3	student_3	7	question_7_txt
3	student_3	1	question_1_txt
3	student_3	8	question_8_txt
3	student_3	2	question_2_txt
3	student_3	5	question_5_txt
3	student_3	3	question_3_txt
4	student_4	6	question_6_txt
4	student_4	1	question_1_txt
4	student_4	2	question_2_txt
4	student_4	5	question_5_txt
4	student_4	3	question_3_txt
4	student_4	4	question_4_txt
4	student_4	7	question_7_txt
4	student_4	8	question_8_txt
5	student_5	4	question_4_txt
5	student_5	3	question_3_txt
5	student_5	5	question_5_txt
5	student_5	2	question_2_txt
5	student_5	8	question_8_txt
5	student_5	7	question_7_txt
5	student_5	1	question_1_txt
5	student_5	6	question_6_txt
6	student_6	8	question_8_txt
6	student_6	4	question_4_txt
6	student_6	3	question_3_txt
6	student_6	5	question_5_txt
6	student_6	2	question_2_txt
6	student_6	6	question_6_txt
6	student_6	7	question_7_txt
6	student_6	1	question_1_txt