strongly urge you to change your table, so that there is only one question/answer per row
CREATE TABLE answers
( question_no INTEGER NOT NULL PRIMARY KEY
, answer CHAR(9) NOT NULL
);
INSERT INTO answers VALUES
( 1 , 'A' )
,( 2 , 'A' )
,( 3 , 'C' )
,( 4 , 'A' )
,( 5 , 'C' )
,( 6 , 'C' )
,( 7 , 'A' )
,( 8 , 'C' )
,( 9 , 'C' )
,(10 , 'B' )
;