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 the steps needed to create a scheduled job?

886

---

How to download and install the scaled-down database adventureworkslt?

954

---

what are defaults? : Sql server database administration

1008

---

What is Dependency Injection and provide example?

1042

---

Explain relational data?

860

---

How to transfer a table from one schema to another?

940

---

What are the differences between lost updates and uncommitted dependencies?

1015

---

What are recommended options to be used while using db mirroring? : sql server database administration

1072

---

What are sql server functions?

939

---

What are key constraints?

929

---

What is policy based management (pbm)? : sql server database administration

931

---

Explain the steps to create and execute a user-defined function in the sql server?

921

---

What are the types of joins in sql?

1058

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

913

---

What new data source types were added in ssrs 2014?

154

---