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

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 ...