Here are two definitions: Fixed length records:- 1.All the records in the file are of same size. 2. Leads to memory wast
Posted: Fri Jul 08, 2022 7:26 am
Here are two definitions:
Fixed length records:-
1.All the records in the file are of same size.
2. Leads to memory wastage.
3. Access of the records is easier and faster.
4. Exact location of the records can be calculated
Variable length records:-
1.Different records in the file have different sizes.
2. Memory efficient.
3. Access of the records is slower. .
Variable length records arise in database systems in differentways :
Give a REAL LIFE example of when you would usea Fixed Length record AND when you would use a VariableLength Record
Fixed length records:-
1.All the records in the file are of same size.
2. Leads to memory wastage.
3. Access of the records is easier and faster.
4. Exact location of the records can be calculated
Variable length records:-
1.Different records in the file have different sizes.
2. Memory efficient.
3. Access of the records is slower. .
Variable length records arise in database systems in differentways :
Give a REAL LIFE example of when you would usea Fixed Length record AND when you would use a VariableLength Record