Home » MCQs » DBMS MCQs » DBMS File Organization Storage MCQs

A variable-length record is kept in the database system using which of the following methods

14. A variable-length record is kept in the database system using which of the following methods:

1. Multiple record types can be stored in a single file.
2. Record types for repeating fields like arrays or multisets are kept.
3. Variable lengths are enabled either for one field or for multiple fields so that it can be used as a Record type.
4. All of the above

Answer: D) All of the above

Explanation:

A variable-length record is kept in the database system using the following methods:

1. Multiple record types can be stored in a single file.
2. Record types for repeating fields like arrays or multisets are kept.
3. Variable lengths are enabled either for one field or for multiple fields so that it can be used as a Record type.