Indexed sequential access file combines both sequential file and direct access file organization. In indexed sequential access files, records are stored randomly on a direct access device such as a magnetic disk by a primary key. This file has multiple keys. These keys can be alphanumeric in which the records […]
File Organization
November 21, 2024
Files The file is a collection of records related to each other. The file size is limited by the size of the memory and storage medium. There are two important features of the file: 1. File Activity 2. File Volatility File activity: It specifies that percent of actual records proceed […]
Transactions in DBMS
November 21, 2024
What are Transactions in DBMS? A small unit of a program that contains several low level tasks are called Transactions. Basic Concept of transaction : A transaction is a unit of program execution that accesses and possibly updates various data items in a database. Example : Transaction to transfer ₹50 […]