Here are two definitions: Fixed length records:- 1.All the records in the file are of same size. 2. Leads to memory wast

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Here are two definitions: Fixed length records:- 1.All the records in the file are of same size. 2. Leads to memory wast

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply