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.

What are the requirements on sql server network connections?

929

---

How to specify the collation for a character data type in ms sql server?

983

---

What is the new security features added in sql server 2014? : sql server security

964

---

can you implement data mining in SSRS?

142

---

When you should use a low fill factor?

957

---

what protocol both networks use? : Sql server database administration

944

---

What is difference between joins and subqueries?

1071

---

Do you know what are the restrictions that views have to follow?

1039

---

What are cursors in ms sql server?

1132

---

Tell me in brief how sql server enhances scalability of the database system?

954

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

930

---

What is the difference between sdf and mdf?

1261

---

How many types of objects are there?

963

---

Can another user execute your local temporary stored procedures?

954

---

Explain about remote stored procedure?

980

---