Hi Friend,

Simply, there would be 6 tables. Each table consists of different questions. Give them names as set1, set2, set3,answers1,answers2,answers3. The format of all the tables would be same. Same fields are there.

table set1(ques,op1,op2,op3,op4,ans) and table answers1(id,ans).

table set2(ques,op1,op2,op3,op4,ans) and table answers2(id,ans).

table set3(ques,op1,op2,op3,op4,ans) and table answers3(id,ans).

In the above tables, ans field of each set should be equal to the ans field of answers respectively.

But, you have to select the table names randomly. Accordingly, retrieve the data from the table. This will provide different questions to different students at a time.

For selecting table randomly, you use the following code:

String[] tables = { "set1", "set2", "set3"};
        Random r = new Random();
        int s=r.nextInt(tables.length);
        String tt = tables[s];

Then use the variable 'tt' in your query.

Hope that it will be helpful for you.

Thanks