Technical Interview Questions
The transparent DBMS is a type of DBMS which keeps its physical structure hidden from users. Physical structure or physical storage structure implies to the memory manager of the DBMS, and it describes how the data stored on disk. A transparent DBMS (Database Management System) is one that provides a seamless interface to users and … Read more
A checkpoint is like a snapshot of the DBMS state. Using checkpoints, the DBMS can reduce the amount of work to be done during a restart in the event of subsequent crashes. Checkpoints are used for the recovery of the database after the system crash. Checkpoints are used in the log-based recovery system. When due … Read more
The Checkpoint is a type of mechanism where all the previous logs are removed from the system and permanently stored in the storage disk. There are two ways which can help the DBMS in recovering and maintaining the ACID properties, and they are- maintaining the log of each transaction and maintaining shadow pages. So, when … Read more
Redundancy control Restriction for unauthorized access Provides multiple user interfaces Provides backup and recovery Enforces integrity constraints Ensure data consistency Easy accessibility Easy data extraction and data processing due to the use of queries The advantages of a Database Management System (DBMS) include: Data Centralization: DBMS allows for centralized control and management of data, ensuring … Read more
The collection of database and DBMS software together is known as a database system. Through the database system, we can perform many activities such as- The data can be stored in the database with ease, and there are no issues of data redundancy and data inconsistency. The data will be extracted from the database using … Read more