Home »
MCQs »
DBMS MCQs
DBMS Sequential File Organization MCQs
DBMS Sequential File Organization MCQs: This section contains multiple-choice questions and answers on Sequential File Organization in DBMS.
Submitted by Anushree Goswami, on April 21, 2022
1. Which of the following is the easiest method for File Organization?
- Hash FO
- ISAM
- Sequential FO
- None
Answer: C) Sequential FO
Explanation:
Sequential FO is the easiest method for File Organization.
Discuss this Question
2. How are the files stored in Sequential FO?
- Sequentially
- Hierarchically
- FIFO
- LIFO
Answer: A) Sequentially
Explanation:
The files are stored sequentially in Sequential FO.
Discuss this Question
3. In how many ways can the Sequential FO be implemented?
- 2
- 3
- 4
- 5
Answer: A) 2
Explanation:
Sequential FO can be implemented in 2 ways.
Discuss this Question
4. The record is stored in a sequence, i.e., one after the other, using the ___ Method.
- Pile File
- Sorted File
- Both A and B
- None of the above
Answer: A) Pile File
Explanation:
The record is stored in a sequence, i.e., one after the other, using the Pile File Method.
Discuss this Question
5. With the Pile File Method, there will be no rearranging of records, as each record will be inserted into the tables in order of ___.
- Repetition
- Updation
- Deletion
- Insertion
Answer: D) Insertion
Explanation:
With the Pile File Method, there will be no rearranging of records, as each record will be inserted into the tables in order of insertion.
Discuss this Question
6. The memory blocks will be searched if any record needs to be ___.
- Updated
- Deleted
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The memory blocks will be searched if any record needs to be updated or deleted.
Discuss this Question
7. A new record is inserted when the record has been found and marked for ____.
- Updation
- Addition
- Insertion
- Deletion
Answer: D) Deletion
Explanation:
A new record is inserted when the record has been found and marked for deletion.
Discuss this Question
8. A record is a ___ in the table.
- Row
- Column
- Data
- Field
Answer: A) Row
Explanation:
A record is a row in the table.
Discuss this Question
9. When you use the Sorted File method, the new record is always appended at the end of the file, and then the sequence is sorted in ___.
- Ascending order
- Descending order
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
When you use the Sorted File method, the new record is always appended at the end of the file, and then the sequence is sorted in ascending order or descending order.
Discuss this Question
10. A primary key or any other key determines how records are ___.
- Added
- Updated
- Deleted
- Sorted
Answer: D) Sorted
Explanation:
A primary key or any other key determines how records are sorted.
Discuss this Question
11. Modified records are placed in the right place after they have been sorted and updated by the ____ method.
- Pile File
- Sorted File
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Modified records are placed in the right place after they have been sorted and updated by the sorted file method.
Discuss this Question
12. The ___ amount of data can be processed quickly and efficiently with Sequential File Organization.
- Small
- Large
- Little
- Few
Answer: B) Large
Explanation:
The large amount of data can be processed quickly and efficiently with this method.
Discuss this Question
13. Using sequential file organization, ___ mechanisms such as magnetic tapes can be used to store files for less.
- Recursive
- Consumption
- Storage
- Secure
Answer: C) Storage
Explanation:
Using sequential file organization, storage mechanisms such as magnetic tapes can be used to store files for less.
Discuss this Question
14. What are the PROS of Sequential File Organization?
- The design is simple.
- The data can be stored with little effort.
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The PROS of Sequential File Organization are -
- The design is simple.
- The data can be stored with little effort.
Discuss this Question
15. When the majority of the records need to be accessed _____, such as when calculating a student's grade or generating a salary slip, for example, sequential file organization is used.
- Hierarchically
- Sequentially
- Circular
- In Loop
Answer: B) Sequentially
Explanation:
When the majority of the records need to be accessed sequentially, such as when calculating a student's grade or generating a salary slip, for example, sequential file organization is used.
Discuss this Question
16. Sequential File Organization is used for -
- Report Generation
- Statistical Calculations
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Sequential File Organization is used for Statistical Calculations.
Discuss this Question
17. We waste time if we organize our files ___ as we cannot jump right to the record we need, but we must move ___, which takes time.
- Hierarchically
- Sequentially
- Circular
- In Loop
Answer: B) Sequentially
Explanation:
We waste time if we organize our files sequentially as we cannot jump right to the record we need, but we must move sequentially, which takes time.
Discuss this Question
18. It takes longer and requires ___ space to sort records when using a sorted file method.
- More
- Less
- Medium
- Average
Answer: A) More
Explanation:
It takes longer and requires more space to sort records when using a sorted file method.
Discuss this Question