Answer Posted / balu

I Agree with the point one but not agreed with the next one

"its uses mainly Load balancing and Fault tolerance."

It is not like all the tier 3 system will use the above.

Loadbalancing and fault tolerance will increase the
availablility and scalablity of the System

What does the on delete cascade option do?

999

---

Write a program to fetch first 10 records from a file?

988

---

What is the difference between local and global temporary tables?

1126

---

What happens if ntwdblib.dll is missing on your machine?

1129

---

What is the partitioning method?

1004

---

difference between Clustered index and non clustered index ?

977

---

What is the difference between dbcc indexdefrag and dbcc reindex?

966

---

When would you use sql joins?

939

---

What are subqueries in sql server? Explain its properties.

996

---

Explain system functions or built-in functions? What are different types of system functions?

955

---

What is row_number()?

970

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1167

---

Explain intellisense for query editing

1015

---

What is a mutating table error and how can you get around it?

1026

---

What are the new features are introduced in sql server 2012 reporting services?

147

---