Answer Posted / ivreddy

Basically 2 tier architecture : This has 2 parts namely
client (front
end) and database (back end).The window application
generally developed in this technology

3 tier architecture :
1 Client-front end (request is given through client)
2.business logic :Middle layer (protocols are used for
processing the request)
3. Database :back end (response is given to the client)
Web applications are good examples for 3 tier architecture
The above answer ,i found in one of the sites.

How to display a past time in days, hours and minutes?

1006

---

Explain active/passive and active/active cluster configurations?

1049

---

What is the name of the Database which IBM mainframe uses?

969

---

Do you know how to store and query spatial data?

1027

---

Can you force a query to use a specific index?

930

---

How to create stored procedures with parameters in ms sql server?

1049

---

how to control the amount of free space in your index pages? : Sql server database administration

1022

---

How to delete duplicate rows?

974

---

Does index speed up select statements?

1004

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1247

---

Do comments need to go in a special place in sql server 2005?

846

---

Is it possible in sql table to have more than one foreign key?

1015

---

What is a schema in ms sql server 2005?

952

---

query processing

2147

---

Do you know what is a with(nolock)?

1045

---