Which of the following is not an allocation unit

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

(Continued from previous question...)

Which of the following is not an allocation unit in SQL Server 2005?

Answer
TEXT_IN_ROW_DATA

Explanation
The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit.

(Continued on next question...)

Other Job Interview Questions

• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• Is it possible to build an index on a view
• What is row versioning in SQL Server 2005?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• What is an index? What types of indexes are available in SQL Server 2000?
• What does CONTINUE do in T-SQL?
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?
• More...