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.

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

943

---

What are “phantom rows”?

1661

---

How to find out the list schema name and table name for the database?

942

---

What are subquery and its properties?

1049

---

What is self join in sql server joins?

1061

---

Write a sql query to display the current date?

1094

---

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

149

---

Explain external key management in sql server 2008

889

---

What is table level trigger?

1022

---

How to create and drop temp table in sql server?

1051

---

Is truncate a dml command?

951

---

What is forward - only cursors / read only cursor?

1091

---

what's the difference between a primary key and a unique key? : Sql server database administration

954

---

What is cursors?

1187

---

How to drop existing indexes in ms sql server?

1072

---