Answer Posted / sandeep

In my point of view....

2 tier means client and server. In this system client
application interracts directly with server(means Database
server)by means of connection string. This architecture is
used in windows applications. So if any changes is happend
in business rules then we shud make changes in every
clients that were installed in different locations. More
over this system doesnt support scalability and high
availability(clustering). This system is used for small
business system.

3 Tier is for very big systems having complex business
rules . In this system apart from 2 tier a middle layer is
introduced, that is application layer. This layer departs
the direct connection of client with database. So many
features and standards can be achieved. Web applications
are using this architecture. This application and database
layers can be in one machine or in differents machines
located in remote areas.


am I rite ? unless please correct me.

thanks

What is acid mean in sql server?

1119

---

What are the advantages of the mirroring?

1094

---

What is log in sql server?

1148

---

Explain what is lock escalation and what is its purpose?

932

---

When would you use the stored procedures or functions?

1000

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1094

---

What is the difference between system objects and user objects?

1162

---

Explain what are the restrictions while creating batches in sql server?

1070

---

Can two tables share the same primary key?

927

---

Explain the microsoft sql server delete command?

1024

---

Explain the steps needed to create a scheduled job?

935

---

What is the difference between a primary key and a unique key? Are they the same?

1077

---

What are the different kinds of ssrs reports?

214

---

What is the stored procedure?

1009

---

What is the difference between sdf and mdf?

1300

---