Home »
MCQs »
DBMS MCQs
DBMS Cluster File Organization MCQs
DBMS Cluster File Organization MCQs: This section contains multiple-choice questions and answers on Cluster File Organization in DBMS.
Submitted by Anushree Goswami, on April 23, 2022
1. This is known as ____ when there are more than two records in a single file.
- Merging
- Adding
- Dissolving
- Clustering
Answer: D) Clustering
Explanation:
This is known as clustering when there are more than two records in a single file.
Discuss this Question
2. Each file will contain ____ tables, but the key attributes used to map each table together will only be stored once for each file.
- One
- Two
- Two or more
- None
Answer: C) Two or more
Explanation:
Each file will contain two or more tables, but the key attributes used to map each table together will only be stored once for each file.
Discuss this Question
3. Using this method, you can search for different records in different files at a cost.
- Lower
- Higher
- Medium
- None
Answer: A) Lower
Explanation:
Using this method, you can search for different records in different files at a lower cost.
Discuss this Question
4. Cluster files are used for ___ tables with the same conditions frequently.
- Distributing
- Joining
- Spreading
- Breaking
Answer: B) Joining
Explanation:
Cluster files are used for joining tables with the same conditions frequently.
Discuss this Question
5. ___ records from both tables will be returned by these joins.
- All
- None
- Only a few
- All of the above
Answer: C) Only a few
Explanation:
Only a few records from both tables will be returned by these joins.
Discuss this Question
6. Any record can be directly inserted, updated, or deleted using this method.
- Inserted
- Updated
- Deleted
- All of the above
Answer: D) All of the above
Explanation:
Any record can be directly inserted, updated, or deleted using this method.
Discuss this Question
7. Sorting is based on the key that is used for ____.
- Sorting
- Searching
- Storing
- Solving
Answer: B) Searching
Explanation:
Sorting is based on the key that is used for searching.
Discuss this Question
8. Cluster keys are used to ___ tables.
- Sorting
- Searching
- Storing
- Solving
Answer: D) Solving
Explanation:
Cluster keys are used to join tables.
Discuss this Question
9. How many types are there of Cluster FO?
- 2
- 3
- 4
- 5
Answer: A) 2
Explanation:
There are 2 types of Cluster FO.
Discuss this Question
10. Which of the following is the type of Cluster FO?
- Indexed Clusters
- Hash Clusters
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The type of Cluster FO are -
- Indexed Clusters
- Hash Clusters
Discuss this Question
11. Hash clusters store records based on their ___ key instead of the cluster key. We then store the records that have the same hash key value.
- Primary
- Foreign
- Hash
- Alternate
Answer: C) Hash
Explanation:
Hash clusters store records based on their hash key instead of the cluster key. We then store the records that have the same hash key value.
Discuss this Question
12. When tables with the ___ joining condition are frequently joined, the cluster file organization is used.
- Same
- Different
- Similar
- None
Answer: A) Same
Explanation:
When tables with the same joining condition are frequently joined, the cluster file organization is used.
Discuss this Question
13. When the tables map ___, the method provides a fast result.
- 1:1
- 1:M
- M:1
- M:M
Answer: B) 1:M
Explanation:
When the tables map 1:M, the method provides a fast result.
Discuss this Question
14. For very large databases, this method performs ___.
- Effectively
- Nicely
- Better
- Poorly
Answer: D) Poorly
Explanation:
For very large databases, this method performs poorly.
Discuss this Question
15. The method cannot be used if there is a change in joining conditions, since traversing the file takes a ___ time if we change the joining conditions.
- Less
- Long
- Little
- Few
Answer: B) Long
Explanation:
The method cannot be used if there is a change in joining conditions, since traversing the file takes a long time if we change the joining conditions.
Discuss this Question
16. Tables with a ___ condition are not suitable for this method.
- 1:1
- 1:M
- M:1
- M:M
Answer: A) 1:1
Explanation:
Tables with a 1:1 condition are not suitable for this method.
Discuss this Question