What's an allocation unit?

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

(Continued from previous question...)

What's an allocation unit?

Answer: A collection of pages in a table based on page type.
Explanation: An allocation unit is a collection of pages within a heap or B-tree. It is based on on the page type (LOB data in row, LOB data out of row, overflow data). It can be of any size and crosses extents.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between a return parameter and an OUTPUT parameter?
• How many users can be added to an application role in SQL Server 2005?
• What is the scope of the control permission in SQL Server 2005?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• What happens when a transaction fails on the publisher?
• You are looking to setup a large Notification Services application...
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• You wish to initialize subscribers to your SQL Server 2005 database using FTP. Which versions can you do this with?
• More...