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

Which of the following is the problem that occur due to fixed size?

10. Which of the following is the problem that occur due to fixed size?

1. The ability to read or write into a record that contains subparts that are partially stored in more than one block depends on access to all of the blocks that contain the subparts.
2. In such an organization, deleting a record is difficult.
3. In that case, a new record or part of a record fills up the block if the existing record's size is less than the block size.
4. All of the above

Answer: D) All of the above

Explanation:

The problems that occur due to fixed size -

1. The ability to read or write into a record that contains subparts that are partially stored in more than one block depends on access to all of the blocks that contain the subparts.
2. In such an organization, deleting a record is difficult.
3. In that case, a new record or part of a record fills up the block if the existing record's size is less than the block size.