1. Categories >> Software >> Databases >> DB Architecture
  2. Suggest New Category

What are pages and extents? : sql server architect

Question Posted / vaidehi sharan


What are pages and extents? : sql server architect..

Answer / Kuldeep Beshra

In SQL Server, a page is the smallest unit of storage in a database file. It holds a maximum of 8192 bytes of data and associated metadata. An extent is a collection of eight contiguous pages, providing 64KB of storage space.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Architecture Interview Questions

Brief theory of Network, Hierarchical schemas and their properties

1 Answers  

What is internal database?

1 Answers  

Explain about the return statement?

1 Answers  

Do you know what the restrictions applicable while creating views are? : sql server architect

1 Answers  

What is Relational Calculus?

1 Answers  

What is Lossless join property?

1 Answers  

What is an Entity type?

1 Answers  

What is Relational Algebra?

1 Answers  

What is Relationship set?

1 Answers  

What does n tier mean?

1 Answers  

What is the difference between 3 tier and 3 layer architecture?

1 Answers  

What is 4NF?

1 Answers  

For more DB Architecture Interview Questions Click Here
Categories