Home »
MCQs »
DBMS MCQs
DBMS File Organization MCQs
DBMS File Organization MCQs: This section contains multiple-choice questions and answers on File Organization in DBMS.
Submitted by Anushree Goswami, on April 22, 2022
1. ___ are contained in the File.
- Rows
- Columns
- Records
- Tables
Answer: C) Records
Explanation:
Records are contained in the File.
Discuss this Question
2. We can access records by using the ___ key.
- Primary
- Foreign
- Alternate
- Composite
Answer: A) Primary
Explanation:
We can access records by using the primary key.
Discuss this Question
3. Based on the type of file organization for a given set of records, we can determine the ___ of access.
- Type
- Frequency
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Based on the type of file organization for a given set of records, we can determine the type and frequency of access.
Discuss this Question
4. Records are organized ___ based on logical relationships.
- Analytically
- Logically
- Reasonably
- None
Answer: B) Logically
Explanation:
Records are organized logically based on logical relationships.
Discuss this Question
5. Defining how a ___ is mapped onto a block of hard disk space is done using this method.
- Database
- File Record
- Data
- None
Answer: B) File Record
Explanation:
Defining how a file record is mapped onto a block of hard disk space is done using this method.
Discuss this Question
6. Organizing your files according to their blocks and putting those blocks onto a storage medium is referred to as ___.
- Data organization
- File organization
- Recursive organization
- None
Answer: B) File organization
Explanation:
Organizing your files according to their blocks and putting those blocks onto a storage medium is referred to as file organization.
Discuss this Question
7. Using multiple files and storing ___ record in each is the first method of mapping a database to a file.
- Multiple
- Only a Single
- Two
- Three
Answer: B) Only a Single
Explanation:
Using multiple files and storing only a single record in each is the first method of mapping a database to a file.
Discuss this Question
8. Our files can also be organized so that different lengths of ___ can be included.
- Database
- Records
- Data
- None
Answer: B) Records
Explanation:
Our files can also be organized so that different lengths of records can be included.
Discuss this Question
9. The implementation of files of fixed length records is simpler than that of files of ___ length records.
- One
- Single
- Simple
- Variable
Answer: D) Variable
Explanation:
The implementation of files of fixed length records is simpler than that of files of variable length records.
Discuss this Question
10. ___ may be selected as quickly as possible because it contains an optimal selection of ___.
- Records
- Database
- Tables
- Rows
Answer: A) Records
Explanation:
Records may be selected as quickly as possible because it contains an optimal selection of records.
Discuss this Question
11. Transactions on the records should be performed quickly and easily, whether they are ___ them.
- Inserting
- Deleting
- Updating
- All of the above
Answer: D) All of the above
Explanation:
Transactions on the records should be performed quickly and easily, whether they are inserting, deleting, or updating them.
Discuss this Question
12. ___ cannot be created by inserting, updating, or deleting records.
- Dividends
- Multiples
- Duplicates
- Addons
Answer: C) Duplicates
Explanation:
Duplicates cannot be created by inserting, updating, or deleting records.
Discuss this Question
13. Duplicates cannot be created by inserting, updating, or deleting records.
- More
- Little
- High
- Much
Answer: B) Little
Explanation:
Documents should be stored efficiently so that they cost as little as possible to store.
Discuss this Question
14. How many types of file organizations are there?
- 5
- 6
- 7
- 8
Answer: B) 6
Explanation:
There are 6 types of file organizations.
Discuss this Question
15. Which of the following is a type of file organization?
- Sequential FO
- Heap FO
- Hash FO
- All of the above
Answer: D) All of the above
Explanation:
The type of file organizations are -
- Sequential FO
- Heap FO
- Hash FO
- ISAM
- B+ Tree FO
- Cluster FO
Discuss this Question