The "Random()" function should do the trick:

Cursor c= db.query("questiondata",null,null,null,null,null,"RANDOM() limit 1");

(see also http://youku.io/questions/218242/random-in-sqlite-and-android-sdk)

In SQL it is easy to get an random record:

SELECT * FROM EMPLOYEES ORDER BY RANDOM() LIMIT 1

I must point out that both the solutions given prior to my answer are valid and will work, but you should keep in mind that the RANDOM() function is "slow", meaning that, depending on the number of records in the table, it may proportionally slow down the execution of the query.

Another method would be to use limit

SELECT COUNT(*) AS n FROM questiondata;

get a random number x between 0 and n

SELECT * FROM questiondata LIMIT 1 OFFSET x;

http://stackoverflow.com/questions/15514124/android-retrieving-random-entry-from-sqlite-database

http://stackoverflow.com/questions/23628464/android-sqlite-getting-data-from-database-randomly

http://stackoverflow.com/questions/28249169/android-get-random-record-in-sqlite