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

Explain what are the events recorded in a transaction log?

1051

---

What does <> symbol mean?

1027

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1050

---

Explain a join?

1121

---

What are translations and its use? : sql server analysis services, ssas

1082

---

What is an indexing technique?

981

---

What is difference between inner join and full join?

1115

---

What are the 10 characteristics of data quality?

1002

---

What is delete query?

990

---

How to locate and take substrings with charindex() and substring() functions?

1073

---

What is the cartesian product of the table?

1003

---

How to read data in a table with "select" statements?

1028

---

How to enable tcp/ip protocol on a sql server?

1212

---

What is the difference between the application object and session object?

1121

---

How to create a view with data from multiple tables?

1063

---