Generally when we fetch data from sql server is in same order. or We can fetch data in ascending or descending order. But to fetch data randomly for each time use this query.
Suppose there is a table Que where all the questions are stored and another table QChoice which store the Choices for each question
Structure of QChoice is like that:
Ch_id int identity(1,1),
Qid int,
Choice
Qid is quitionid which is fetched from Que table
now to show Choices randomly for each question use the query:
Select * from QChoice where qid='1' order by newid()
NewID() is the function used for generating randomly result.