i want to develope a page for online test using asp.net
with c#.net. so, how to insert the questions in the
database sqlserver2000 and how to pick the questions
randomly when user login for test. plz send the code for
this....

Answers were Sorted based on User's Feedback



i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / varasri

the query for random selection is
select * from tablename order by newid()

Is This Answer Correct ?    32 Yes 8 No

i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / raju

by using RAND(value) u can get the random Questions....like
below


Select * from table1 where ID=(5*Rand()+1)

Is This Answer Correct ?    16 Yes 6 No

i want to develope a page for online test using asp.net with c#.net. so, how to insert the questi..

Answer / ravi

In ORACLE
select * from questions
order by (id * dbms_random.random)

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More ASP.NET Interview Questions

What is actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?

0 Answers   MindCracker,


if we establish the cinnection with connection string tag in web.config file,can i go for encrypt and decrypt with that?

1 Answers  


Is react a template engine?

0 Answers  


What do you understand from custom control?

0 Answers   C DAC, CDAC,


Are there resources online with tips on asp to asp.net conversions?

0 Answers  






Can we use multiple forms in single asp.net application?

3 Answers   Polaris,


Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?

0 Answers  


Write the different features of a Thread and a Process?

0 Answers   Siebel,


Define view state.

0 Answers  


Explain about asp.net caching?

0 Answers  


In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?

0 Answers  


what is the difference b/w Asp.net server controls and html server controls in .net?

2 Answers   iGate, Profiniti Systems,


Categories