Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Answer / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

What are functions

3 Answers  

---

Explain the database you used in your final year project?

0 Answers   Wipro,

---

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

---

Define clusters?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---