Select one answer The exam has timed out. Click here to start a new session for this exam © Accelerated Ideas - 2008                                                                            Accelerated Ideas - Software Solutions for Today's world
       Question and Exam Time       Proceed to the next question Next Question We appreciate any feedback on our practice exams, or if you would like to recommend some additional questions please contact us Got a comment? Submit as answer to this question                    

End the exam now and calculate your current score You can rate this exam once you have finished it Rate Exam                                                                                     Help us to improve our online exams, donate via PayPal. Its simple and takes only a few minutes to help us improve our site for everyone Accelerated Ideas was founded to provide you with the best free software, training and resources Help us Exam : 70229 Time Taken : 0 mins   Select one answer: FETCH RELATIVE. Although you could use the NEXT and PRIOR fetch statements it is better to use the RELATIVE fetch to jump the desired number of rows back or forwards e.g. FETCH RELATIVE -2, jumps back 2 rows in the cursor set.        		         Choose another exam Sample Questions Go to Extras Cert Planner Go to Home    End Exam   Our Team Microsoft Practice Exams Submit Answer Options Credits Home Links You have created a script to run against your SQL Server 2000 database. The script uses cursors to update data in a set pattern for a given set of time conditions. You want to use a FETCH statement that allows you to jump forward or backward a set number of rows from the current cursor position.

Which FETCH statement should you use to achieve this?   









            
Free online Microsoft practice exams for MCAD and MCSD certifications. Exams include 70-306, 70-315, 70-320, 70-229, 70-536, 70-552, 70-526, 70-528, 70-529. Developing Windows and Web application using Microsoft Visual Studio.NET. SQL Server 2000 design and implementation. All exam questions are free for online users. New practice exams coming soon for MCTS, MCPD certifications using Visual Studio 2005. Our site does not contain braindumps nor braindump style material which disrespects and lowers the value of Microsoft certifications. We are fully committed to ensuring the integrity of Microsoft's exams and their importance in the business world.