Mobiprep has created last-minute notes for all topics of Database Architecture to help you with the revision of concepts for your university examinations. So let’s get started with the lecture notes on Database Architecture.
Our team has curated a list of the most important questions asked in universities such as DU, DTU, VIT, SRM, IP, Pune University, Manipal University, and many more. The questions are created from the previous year's question papers of colleges and universities.
Question 1 - Define Data Abstraction.
Answer - Data Abstraction is the process of hiding the background and implementation details that are irrelevant to the end-user. Data abstraction allows the user to view only the essential information. Using data abstraction, the user can easily interact with the database, without knowing the database implementation.
Question 2 - What are the three levels of Abstraction in DBMS?
Answer - There are three levels of database abstraction. They are:
Physical level - The Physical level is the lowest data abstraction level. It deals with the physical storage of data in the disks or some other secondary storage devices. It explains the ordering of records on the disks and the different indexing methods used. This level is usually hidden from the application programmers.
Logical Level or Conceptual Level - This level deals with the organization of data (generally in the form of tables). It deals with the attributes and records of the tables, and also the relationship between the tables. Details of the physical level are removed at this level using abstraction. This level is used by Database Administrators and Application programmers.
View level - The View level is the highest level of abstraction. It provides the abstracted view tailored to a user. All the internal implementations of the database are abstracted in this level. The data is presented in a useful form for each user.
Question 3 - Explain the two tier architecture of DBMS.
Answer - The DBMS Two-Tier architecture is similar to the Client-Server model. The user application programs are on the Client side, and the database is one the server side. Here, the user application can directly communicate with the Database Server, by establishing a communication link. The two tier architecture can be understood clearly from the following block diagram.
Question 4 - Explain the three tier architecture of DBMS.
Answer - The DBMS Three-Tier architecture consists of three major components. They are:
Client-side application (or) user interface
Here, unlike the 2 two-tier architecture, the client application cannot directly communicate with the database. Instead, it communicates with the application on the server side, which in turn retrieves the required data from the database.