How are modified extents tracked in SQL Server 2

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

(Continued from previous question...)

How are modified extents tracked in SQL Server 2005 (which internal structures)?

Answer
Differential Change Map and Bulk Change Map

Explanation
There are two internal structures that track extents modified by bulk copy operations or that have changed since the last full backup. They are the Differential Changed Map (DCM) and the Bulk Changed Map (BCM).

(Continued on next question...)

Other Job Interview Questions

• What does the DUMP command do?
• In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• How large a database can you have in this edition of SQL Server 2005? ...
• You are troubleshooting a Service Broker application ...
• True or false, Report Builder supports user defined run time parameters?
• What is the default type of XML data if you do not specify an arguement?
• Which of the following is not available to you?
• The TRUSTWORTHY database property is by default?
• Which RAID levels store parity information?
• More...