Questions and answers database design for Core Data
So, this is


an MCQ (Multiple Choice Questionnaire) 
a test where users will only take it once
there are time constraints


I think that you've over-engineered on your first pass - you woudn't be the first! :-)

A preliminary proposal would be be as follows:

CREATE TABLE Student (Student_ID int, Name VARCHAR(25));

CREATE TABLE Question (Question_ID int, Name VARCHAR(25), 
                       Question_Text VARCHAR(64000), 
                       Answer1 VARCHAR(4096), 
                       Answer2 VARCHAR(4096), 
                       Answer3 VARCHAR(4096), 
                       Correct_Answer int,
                       Threshold_1 int,  -- time constraints per question
                       Points_T1   int,
                       Threshold_2 int,
                       Points_T2   int,
                       Threshold_3 int,
                       Points_T3   int);


The reason I put the thresholds in with the question is that you have said that they may vary with the question.

CREATE TABLE Student_Response (Student_ID int, 
                               Question_ID int, 
                               Student_Answer int,  
                               Answer_Time int, 
                               Answer_Points int);


Now, from here, SQLite doesn't support calculated/computed/generated fields, and from here nor does it support IF or CASE statements in TRIGGERs, so I think you're going to have to manage the calculation of Answer_Points in application code.

This will obviously depend on 


whether the answer is correct and 
the time taken to answer


You will also need the RI (Referential Integrity) CONSTRAINTs below:

ALTER TABLE Student_Response
  ADD CONSTRAINT fk_sr_question FOREIGN KEY (Question_ID) 
    REFERENCES Question (Question_ID);
ALTER TABLE Student_Response 
  ADD CONSTRAINT fk_sr_student FOREIGN KEY (Student_ID) 
    REFERENCES Student (Student_ID);
 ALTER TABLE Student_Response 
  ADD CONSTRAINT uq_sr_student_question 
    UNIQUE (Student_ID, Question_ID);


You also said 


  User will answer once a question


so, you will need this UNIQUE CONSTRAINT:

ALTER TABLE Student_Response 
  ADD CONSTRAINT uq_sr_student_question 
    UNIQUE (Student_ID, Question_ID);


.