Question no.7

You need to modify usp_SelectSpeakersByName to support server-side paging. The solution must minimize the amount of development effort required. What should you add to usp_SelectSpeakersByName?

A. A table variable

B. An OFFSET-FETCH clause

C. The ROWNUMBER keyword

D. A recursive common table expression

Correct Answer: B 
Explanation

Explanation/Reference: 
Explanation: http://www.mssqltips.com/sqlservertip/2696/comparing-performance-for-different-sql- serverpaging-methods/ http://msdn.microsoft.com/en-us/library/ms188385.aspx http://msdn.microsoft.com/en-us/library/ms180152.aspx http://msdn.microsoft.com/en-us/library/ms186243.aspx http://msdn.microsoft.com/en-us/library/ms186734.aspx http://www.sqlserver-training.com/how-to-use-offset-fetch-option-in-sql-server-order-byclause/- http://www.sqlservercentral.com/blogs/ juggling_with_sql/2011/11/30/using-offset-and-fetch/