ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How the data stores in a page?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How the data stores in a page?
Answer
# 1		 
The fundamental unit of data storage in SQL Server in the 
page. The disk space allocated to a data file (.mdf 
or, .ndf) in a database is logically divided into pages 
numbered form “0” to ‘n’. Disk I/O operation are performed 
at page level. 
In SQL server, the page is 8 kb. This means SQL Server 
database have 128 pages per MB. Each page begins with a 96 
byte header. That is used to store system information about 
the page.
Page types used in the data files of the SQL Server 
database.
1.)	Data 
2.)	Index
3.)	Text image
4.)	Global allocation map, shared global allocation map
5.)	Page free space.
6.)	Index allocation map
7.)	Bulk changed map
8.)	Differential changed map
** Maximum amount of data and overload that is contained in 
single row on a page is 8060 bytes ()8Kb.
 
Is This Answer Correct ?    0 Yes 0 No
Arunyadav007
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds5
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
plz send every query in sql server2000 Infosys1
How to work on DTS?what is the main requirement? ivan1
How to write a script for upate the data in prod , i have 50000 row are there TCS2
How can we write or define DDL statements in Sql server and DML statements?  2
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
What is transcation?Plz give One example?  2
When do you use SQL Profiler?  2
what is bit data type? and what are the information that can be stored inside a bit column?  2
What is a Linked Server?  1
how to select 5 to 7 rows from a table, which contains 10 rows? IBM14
how will u create "n" possible tables in sql... Oracle1
write coding for importing sql data into a word excel... Oracle1
Can store procedure call by user define function in SQL server? HCL6
What is cursor ? And what is difference between Trigger ? HCL1
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa7
What are the different types of replication? How are they used?  3
When do we use the UPDATE_STATISTICS command?  3
What is RAID and what are different types of RAID configurations? Wipro5
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com