Answer Posted / vaishuparmar

.it's used with aggregate functions.
.there are main 5 aggregate function max,min,sum,avg,and count..
.it returns only one value at a time.
.it fetches the data from the database.
.it returns only first column of first row.

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1021

---

What is ado data control?

995

---

Is entity framework better than ado.net?

1012

---

Which is the feature of ado.net?

1011

---

Explain advantages of ado.net?

1047

---

What are the various methods provided by the DataSet object to generate XML?

1004

---

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

926

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1018

---

Explain the difference between ado and ado.net?

937

---

What is a string variable?

917

---

What is the use of data grid?

955

---

What are dcl commands?

1009

---

How to retrieve the user id which is provided while windows authentication?

1096

---

What is the difference between Optimistic and Pessimistic locking?

977

---

What is the difference between ado.net and oledb?

945

---