Answer Posted / ravi148

hi
2-tier - also called client/server applications which
consist of two separate applications, one server
application (typically a database server like Oracle, MSSQL
or any other standalone database) and a client application.
suppose you want to have many different clients for front-
end would be unwise to copy all the business logic (all the
rules of your application) to each client app.,. so its
better to create a middle layer containing the business
logic, and then let the clients talk with this middle
layer. Thus the clients can relatively easily be changed
for other types of clients, without need for remembering
how was the business logic put together.

3-tier architeture where one tier is the backend database
engine, one is the front end client and one is just in
between them, also named the application server or business
logic node.
its uses mainly Load balancing and Fault tolerance.

please rate the status of my reply so that i can understand
my knowledge.
you can call me at 9951123501 for any queries.

Do you know how to make remote connection in database?

944

---

How to filter records of table in SQL SERVER?

1062

---

Can we call future method from trigger?

917

---

What are the default system databases in sql server 2000?

999

---

Explain important index characteristics?

1019

---

What is set nocount on?

926

---

why would you call update statistics? : Sql server database administration

1063

---

Can we update data in a view?

1010

---

When I delete any data from a table, does the sql server reduce the size of that table?

994

---

What is the correct order of the logical query processing phases?

919

---

Define outer join in sql server joins?

922

---

What is truncate table?

923

---

What is left outer join in sql server joins?

1018

---

How can I know what locks are running on which resource?

938

---

Can you force a query to use a specific index?

927

---