O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Knowledge Measure

  1. True or false: When porting an ISAM application to SQL Server, you should attempt to change as little about the app as possible, particularly with respect to the way that data is accessed.

  2. What WHERE clause element is used with an UPDATE or DELETE command to perform a positioned update or delete?

  3. Is it possible to declare a variable in a stored procedure whose data type is cursor?

  4. True or false: To return a cursor from a stored procedure, you must pass the cursor the procedure's return statement.

  5. List the four types of cursors SQL Server supports.

  6. In terms of resource utilization, what's the difference between DEALLOCATE CURSOR and CLOSE?

  7. What mechanism does SQL Server use to store the data returned by a static cursor?

  8. What automatic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required