Answer Posted / kuldeep kumawat

clustered index make physical table of the underline base table like (PhonBook,Discretionary)
and
Non clustered index is a reference table key of base table.
nonclusterd index has reference key to point a main table record
(like our not book we have index at first page and page number )
Example blow here ..
topics page no
class 20
object 30
asp.net 300
practices Example 330

What is the hierarchy of data in databases?

950

---

What is aggregate root?

1112

---

What is data relation?

927

---

Explain the difference in record set and dataset?

944

---

Why is it important to close an ado.net application?

1028

---

What is the difference in record set and dataset?

1034

---

Explain how can we load multiple tables in to dataset?

949

---

How would you connect to a database by using .NET?

946

---

What is the usage of the dataset object in ado.net?

966

---

How do you update a dataset in ado.net and how do you update database through dataset?

929

---

What is a column variable?

944

---

What are the methods of XML dataset object?

1028

---

Why do we use sqldataadapter?

955

---

What is variable view?

882

---

Name which operations can you not perform on an ado.net dataset?

990

---