Quick Check


1. 

Which caching method is easy to implement but allows you the most control in how it is implemented?

image from book

2. 

What new feature with SQL Server 2005 enables you to receive notifications when the data in your cache has been updated?

image from book

3. 

What are some commonly used alternatives to using a server-side cursor?

image from book

4. 

Which two statements should be executed after all the rows in your cursor are fetched?

image from book

5. 

Which concurrency option should be avoided to minimize blocking?

image from book

Answers

1. 

Control level-caching is easily implemented by adding the OutputCache directive to the top of the HTML. By using control level-caching as opposed to page level-caching, you have more control over what is cached in your Web page.

2. 

Query notifications allow you to receive notifications when the data in your cache has been updated. You can then execute a refresh of the cache and ensure that you have the latest version of the data.

3. 

Often, you can replace a cursor with a single SELECT statement. You can also consider using a WHILE loop, CASE function, and a recursive query.

4. 

You should always include the CLOSE and DEALLOCATE statements after all the data in your cursor has been fetched. This will release all locks and also remove the cursor from server memory.

5. 

The SCROLL_LOCKS option should be avoided, because it assumes updates might occur to the data before the cursor has been closed. Depending on the lock hints specified in the SELECT statement, locks might be issued on the underlying tables by using this option.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net