Question

How can variable length records arise in a file

(a) Storage of multiple record types in a file

(b) Record types that allow variable lengths for one or more fields

(c) Record types that allow repeating fields, such as arrays or multisets

(d) All of the mentioned

This question was addressed to me in semester exam.

The doubt is from File Organization topic in portion Storage and File Structure of RDBMS

Answer 1

Right choice is (d) All of the mentioned

For explanation: Variable length records arise in a system in several ways like, Storage of multiple record types in a file. Record types that allow variable lengths for one or more fields. Record types that allow repeating fields, such as arrays or multisets.