What is a bookmark lookup?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a bookmark lookup?

Answer
An operation where the row in the heap or clustered index is found from the bookmark in the index.

Explanation
A bookmark ID is stored in an index and points back to the actual row in the heap or clustered index of the table. The lookup operation occurs when an index satisfies a search and the actual row is retrieved from the table.

(Continued on next question...)

Other Job Interview Questions

• When starting SQL Server 2005 from the command line, what does the -h switch do?
• You are troubleshooting a Service Broker application ...
• What's SQL Server
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• What does this WHERE clause evaluate to?
• What could be the problem if you know the service is working properly?
• More...