What is the size of an Extent in MS SQL Server?

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

(Continued from previous question...)

What is the size of an Extent in MS SQL Server?

The size of an Extent in MS SQL Server is 64 KB.
An Extent is 8 Pages and each Page has 8 KB.

(Continued on next question...)

Other Job Interview Questions

• What is setup.iss file used for during MS SQL Server installation?
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is the main limitation of the MS SQL Server Developer Edition?
• What is a Named Pipe in MS SQL Server?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What should you do to prepare for MS SQL Server upgrade?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• How do you describe a field in a table in the database?
• What does Default Object refers to in MS SQL Server?
• How do you describe a field in a table in the database?
• More...