ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is the difference between 2-Tier architecture and
3-Tier architecture
 Question Submitted By :: Ashok
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 1
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.
 
Is This Answer Correct ?    64 Yes 12 No
Ravi148
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 2
Thanks Ravi, for a short but a very effective explanation.
 
Is This Answer Correct ?    19 Yes 4 No
Pavan Kumar
 
 
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 3
very good Ravi
thanks
 
Is This Answer Correct ?    9 Yes 2 No
Kinthada Cnu
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 4
is a web application 2 tier or three tier?
 
Is This Answer Correct ?    10 Yes 4 No
Srisri
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 5
thanks ravi
 
Is This Answer Correct ?    5 Yes 2 No
Ravikanth
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 6
very good ravi,thanks
 
Is This Answer Correct ?    3 Yes 0 No
Sandeep
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 7
2 tier architecture is a client-server application...
3 tier architecture is web application.
 
Is This Answer Correct ?    6 Yes 1 No
Ranjithkumar Pedana
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 8
I Agree with the point one but not agreed with the next one

"its uses mainly Load balancing and Fault tolerance."

It is not like all the tier 3 system will use the above.

Loadbalancing and fault tolerance will increase the 
availablility and scalablity of the System
 
Is This Answer Correct ?    2 Yes 0 No
Balu
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 9
2 tier is client server application or in 2 tier one layer 
acts as web+App and another as data layer.
in 3 tier one is web layer 2nd is app layer and third is 
data layer.
web layer = where client end code resides
app layer = where business logic of application resides
data layer  = database layer where database resides
 
Is This Answer Correct ?    1 Yes 0 No
Ashwani
 
  Re: What is the difference between 2-Tier architecture and 3-Tier architecture
Answer
# 10
In 2 tier architecture the application is splitted in to 
two parts which is located in two machines called as client 
and server that is why it is also known as client server 
architecture..in this architecture the business logic 
resides either with the client or with the server where 
database resides, so if client machine  contains the 
business logic then is termed as Fat client coz it has to 
look after the client related as well as business related 
issues where as if business logic resides with the database 
server then it is termed as Fat Server since it has to 
manage the database related as well as business related 
issues so some how either the client or the server 
performance hampers.


in 3 tier architecture the application is physically 
divided and located in  to three different machine one 
takes care only about clientrelated issues known as client 
tier, one second takes care about all the business logic 
related issus and input out taken from the client tier 
known as middle tier and the third contains the database 
and responsible for managing and manipulating all the 
database related issues callled as database tier so this 
architecture is basically used for load balancing and fault 
tolerence.

for further query feel free to mail me 
at:amitjavatech@gmail.com
amit_javatech@yahoo.com
 Thanks.
 
Is This Answer Correct ?    0 Yes 0 No
Amit K. Gautam
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What about UPDATESTATISTICS ? Intelligroup2
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
What is the purpose of using COLLATE in a query?  1
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18  2
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz... Value-Labs5
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?  1
what is the Enterprise manager(2000) and management studio (2005)?  2
What is normalization in Database ?  4
what is a stored procedure and trigger?  2
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
What is a trigger?  6
i want table name basis on column name.  5
Can we create clustered index on non primary key column CTS14
What is transcation?Plz give One example?  2
How the data stores in a page?  1
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required  2
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T2
What is indexed views? plz explain with example?  1
what is normalization? what is denormalization? Satyam5
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??  8
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com