Indexl Question 22 April 2010

1. Can we alter the index?
2. Which system are used in very large number of indexing system ?
3. What happened if the clustered index is not unique ?
4. where logged the entry of index in sql server ?
5. what is default sorting order of index?
6. which constraint is created index by default?
7. what is use of DBCC showconfig?
8. How to use fill factor with pad? Explain
9. Explain hash join and merge join ?
10. What is maximum size of row ?

Index Question -21 April 2010

Date: 20/04/2010
1. If a table has not any index column, table is unordered structure, what will say it unordered structure?
2. What is row locator?
3. Can we create non- clustered index, without clustered index?
4. Can cluster and non- clustered index can be unique?
5. What is role of partitions in table and index?
6. How many non-clustered indexes can be in a table?
7. How maintained the index, when table or view is modified?
8. What is spatial index?
9. What type of data type, where we not create the index?
10. Create Index testIndex on (columnname>
What type of index will get created after executing the above statement ?