Home »
MCQs »
DBMS MCQs
DBMS Indexed Sequential Access Method (ISAM) MCQs
DBMS ISAM MCQs: This section contains multiple-choice questions and answers on Indexed Sequential Access Method (ISAM) in DBMS.
Submitted by Anushree Goswami, on April 22, 2022
1. An advanced sequential file organization method known as ___.
- ASFO
- ISFO
- ISAM
- None
Answer: C) ISAM
Explanation:
A sequential file organization method known as ISAM.
Discuss this Question
2. The ___ key is used to store records in this method.
- Primary
- Foreign
- Alternate
- Composite
Answer: A) Primary
Explanation:
The primary key is used to store records in this method.
Discuss this Question
3. In each primary key, a value for the index is ___ to the record.
- Created
- Mapped
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In each primary key, a value for the index is created and mapped to the record.
Discuss this Question
4. The file ___ is contained in this index.
- Address
- Data
- Row
- Column
Answer: A) Address
Explanation:
The file address is contained in this index.
Discuss this Question
5. The address of a data block is retrieved and the record is retrieved from ___ if any record has to be retrieved based on its index value.
- Storage
- Page
- File
- Memory
Answer: D) Memory
Explanation:
The address of a data block is retrieved and the record is retrieved from memory if any record has to be retrieved based on its index value.
Discuss this Question
6. Because each record has its own data block address, searching a record across a huge database is ___ and quick.
- Simple
- Hard
- Tough
- Slow
Answer: A) Simple
Explanation:
Because each record has its own data block address, searching a record across a huge database is simple and quick.
Discuss this Question
7. ___ are supported by this method.
- Range Retrieval
- Partial Record Retrieval
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Range retrieval and partial record retrieval are supported by this method.
Discuss this Question
8. The ___ key values determine the index, which allows us to retrieve the data for the given value range.
- Primary
- Foreign
- Composite
- Alternate
Answer: A) Primary
Explanation:
The primary key values determine the index, which allows us to retrieve the data for the given value range.
Discuss this Question
9. To store the index value, ___ disk space is required.
- Less
- Few
- Extra
- None
Answer: C) Extra
Explanation:
To store the index value, extra disk space is required.
Discuss this Question
10. In order to maintain the sequence, these files must be reconstructed when new records are ____.
- Inserted
- Deleted
- Updated
- None
Answer: A) Inserted
Explanation:
In order to maintain the sequence, these files must be reconstructed when new records are inserted.
Discuss this Question
11. The space used by the record must be released when it is ___.
- Added
- Deleted
- Updated
- None
Answer: B) Deleted
Explanation:
The space used by the record must be released when it is deleted.
Discuss this Question