What is the purpose of IAM (Index Allocation Map

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

(Continued from previous question...)

What is the purpose of IAM (Index Allocation Map) in MS SQL Server?

An IAM (Index Allocation Map) is a page that records allocations of data pages (IN_ROW_DATA, LOB_DATA and ROW_OVERFLOW_DATA) used for specific table or index.

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• What information do you need to identify a remote MS SQL Server to make a connection request?
• What does Constraint refer to in MS SQL Server?
• What is the different between concurrent connections and concurrent user logins?
• What does Trigger refers to in MS SQL Server?
• What does Trigger refers to in MS SQL Server?
• Can MS SQL Server be used for transation processing as well as data warehousing database?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• What is the size of an Extent in MS SQL Server?
• What two categories you can divide T-SQL statements into?
• More...