All Q&A

Describe the Three-Schema Architecture of DBMS. Distinguish Physical Data Independence and Logical Independence.

27 May, 2022
The goal of the three-schema architecture is to separate the user applications and the physical database. In this architecture, schemas can be defined at 3 levels:

Discuss the ACID properties of transaction.

27 May, 2022
A transaction is a very small unit of a program and it may contain several low-level tasks. A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.

Write short notes: B tree

27 May, 2022
A B-tree is a tree structure where every node corresponds to a disk page and which satisfies the following properties: