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;

Num	s_id	Q_ID_2	Question_id	question_text
1	1	1st	1	question_1_txt
2	1	2nd	2	question_2_txt
3	1	3rd	3	question_3_txt
4	1	4th	4	question_4_txt
5	1	5th	5	question_5_txt
6	1	6th	6	question_6_txt
7	1	7th	7	question_7_txt
8	1	8th	8	question_8_txt
9	2	1st	2	question_2_txt
10	2	2nd	3	question_3_txt
11	2	3rd	4	question_4_txt
12	2	4th	5	question_5_txt
13	2	5th	6	question_6_txt
14	2	6th	7	question_7_txt
15	2	7th	8	question_8_txt
16	2	8th	1	question_1_txt
17	3	1st	3	question_3_txt
18	3	2nd	4	question_4_txt
19	3	3rd	5	question_5_txt
20	3	4th	6	question_6_txt
21	3	5th	7	question_7_txt
22	3	6th	8	question_8_txt
23	3	7th	1	question_1_txt
24	3	8th	2	question_2_txt
25	4	1st	4	question_4_txt
26	4	2nd	5	question_5_txt
27	4	3rd	6	question_6_txt
28	4	4th	7	question_7_txt
29	4	5th	8	question_8_txt
30	4	6th	1	question_1_txt
31	4	7th	2	question_2_txt
32	4	8th	3	question_3_txt
33	5	1st	5	question_5_txt
34	5	2nd	6	question_6_txt
35	5	3rd	7	question_7_txt
36	5	4th	8	question_8_txt
37	5	5th	1	question_1_txt
38	5	6th	2	question_2_txt
39	5	7th	3	question_3_txt
40	5	8th	4	question_4_txt
41	6	1st	6	question_6_txt
42	6	2nd	7	question_7_txt
43	6	3rd	8	question_8_txt
44	6	4th	1	question_1_txt
45	6	5th	2	question_2_txt
46	6	6th	3	question_3_txt
47	6	7th	4	question_4_txt
48	6	8th	5	question_5_txt