InterviewSolution
| 1. |
Explain the difference between a 2-tier and 3-tier architecture in a DBMS. |
|
Answer» The 2-tier architecture refers to the CLIENT-server architecture in which applications at the client end DIRECTLY COMMUNICATE with the database at the server end without any middleware involved. The above picture represents a 2-tier architecture in a DBMS. The 3-tier architecture contains another layer between the client and the server to provide GUI to the users and make the system much more secure and accessible. In this type of architecture, the application present on the client end interacts with an application on the server end which further communicates with the database system. Example – Designing registration form which contains a text box, label, button or a large website on the Internet, etc. The above picture represents a 3-tier architecture in a DBMS. Recommended Tutorials: SQL Interview Questions |
|