By default "FILLFACTOR" value is

Options
- Zero
- One
- Two
- Five


CORRECT ANSWER : Zero

Discussion Board
Fill factor

Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of Page with size 8K. Every page can store one or more rows based on the size of the row. The default value of the Fill Factor is 100, which is same as value 0. The default Fill Factor (100 or 0) will allow the SQL Server to fill the leaf-level pages of an index with the maximum numbers of the rows it can fit. There will be no or very little empty space left in the page, when the fill factor is 100.

Prajakta Pandit 03-6-2017 07:28 AM

fill-factor

The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity.

Fillfactor 09-14-2016 07:50 AM

answer

zero is 100% freespace occuerd


raj 05-31-2015 01:46 AM

SQL oracle 11g

how its zero


hanumantha 01-2-2015 05:50 AM

Doubt

How it is Zero?
Please Tell me any one...

sindhu 11-5-2014 05:09 AM

query

how it is zero ?


bharat 04-5-2014 07:57 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement