===========================================
DBMS MCQ QUESTIONS
MODEL PAPER – 4
====================================================================
1. Which of the following is a
merit of the Sequential File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. No need for an index
table
d. Suitable for dynamic data
updates
Answer: a. Efficient for range
queries
2. What is a merit of the
Hashed File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Reduced storage space
requirements
d. Suitable for applications
with frequent data inserts and deletes
Answer: d. Suitable for
applications with frequent data inserts and deletes
3. Which is a merit of the
Indexed Sequential File Organization?
a. No need for an index
table
b. Efficient for range
queries
c. Random arrangement of
records
d. Reduced storage space
requirements
Answer: b. Efficient for range
queries
Demerits:
4. What is a demerit of the
Heap (Unordered) File Organization?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Requires a complex indexing
structure
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Slow access for
individual record retrieval
5. Which of the following is a
demerit of the Sequential File Organization?
a. Efficient for range
queries
b. Requires additional space
for the index
c. Fast access for individual
record retrieval
d. Suitable for dynamic data
updates
Answer: b. Requires additional
space for the index
6. What is a demerit of the
Clustering File Organization?
a. Faster access for individual
record retrieval
b. Increased complexity in
addressing and storage management
c. No need for an index
table
d. Efficient for range
queries
Answer: b. Increased complexity
in addressing and storage management
7. Which is both a merit and a demerit of the
Dynamic File Organization?
a. Improved efficiency for
range queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Faster access for individual
record retrieval
Answer: b. Increased complexity
in addressing and storage management
Merits:
8. What is a merit of the
B-tree Index Structure?
a. Reduced storage space
requirements
b. Improved efficiency for
range queries
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Improved efficiency
for range queries
9. Which is a merit of the Star
Schema in data warehousing?
a. Reduced storage space
requirements
b. Improved efficiency for
range queries
c. Simplified and efficient
querying for analytical purposes
d. Increased complexity in
addressing and storage management
Answer: c. Simplified and
efficient querying for analytical purposes
Demerits:
10. What is a demerit of the
Multiversion Concurrency Control in file organization?
a. Faster access for
individual record retrieval
b. Increased complexity in
addressing and storage management
c. Suitable for applications
with frequent data inserts and deletes
d. No need for an index
table
Answer: b. Increased
complexity in addressing and storage management
11. Which of the following is
a demerit of the Distributed Hashing in file organization?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
Mixed Merits and Demerits:
12. Which is both a merit and
a demerit of the Dynamic Clustering File Organization?
a. Improved efficiency for
range queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Faster access for
individual record retrieval
Answer: a. Improved efficiency
for range queries
13. What is both a merit and a
demerit of the External Sorting process?
a. Reduced storage space
requirements
b. Increased complexity in
addressing and storage management
c. Improved efficiency for
range queries
d. Fast access for individual
record retrieval
Answer: b. Increased
complexity in addressing and storage management
14. What is a merit of the
Direct File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Reduced storage space
requirements
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Fast access for
individual record retrieval
15. Which is a merit of the
Depth-First Search in file organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Suitable for applications
with frequent data inserts and deletes
d. Fast access for individual
record retrieval
Answer: d. Fast access for
individual record retrieval
16. What is a demerit of the
Radix Tree in file organization?
a. Faster access for
individual record retrieval
b. Increased complexity in
addressing and storage management
c. Suitable for applications
with constant data inserts and deletes
d. No need for an index
table
Answer: b. Increased
complexity in addressing and storage management
17. Which of the following is
a demerit of the Data Replication in a distributed database system?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
18. Which is both a merit and a demerit of the
Linear Probing in hashing for collision resolution?
a. Increased complexity in
addressing and storage management
b. Efficient for range
queries
c. Suitable for applications
with constant data inserts and deletes
d. Reduced storage space
requirements
Answer: a. Increased
complexity in addressing and storage management
19. What is both a merit and a
demerit of the External Sorting process?
a. Reduced storage space
requirements
b. Increased complexity in
addressing and storage management
c. Improved efficiency for
range queries
d. Fast access for individual
record retrieval
Answer: b. Increased
complexity in addressing and storage management
20. What is a merit of the Master File in a
database system?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Reduced storage space
requirements
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Fast access for
individual record retrieval
21. Which is a merit of the
Multilevel Index in file organization?
a. No need for an index
table
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Improved efficiency for
range queries
Answer: d. Improved efficiency
for range queries
22. What is a demerit of the
Distributed Database in file organization?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
23. Which of the following is
a demerit of the Data Dictionary in a database system?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
24. Which is both a merit and
a demerit of the Transaction Log in a database system?
a. Improved efficiency for
range queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Fast access for individual
record retrieval
Answer: b. Increased
complexity in addressing and storage management
25. What is both a merit and a
demerit of the Free Space Management in a file organization?
a. Reduced storage space
requirements
b. Increased complexity in
addressing and storage management
c. Improved efficiency for
range queries
d. Fast access for individual
record retrieval
Answer: b. Increased
complexity in addressing and storage management
26. What is a merit of the
Radix Sort in external sorting?
a. Reduced storage space
requirements
b. Increased complexity in
addressing and storage management
c. Efficient for range
queries
d. Fast access for individual
record retrieval
Answer: d. Fast access for
individual record retrieval
27. Which is a merit of the
Hierarchical File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Reduced storage space
requirements
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Fast access for
individual record retrieval
28. What is a demerit of the Random File
Organization?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. No need for an index
table
d. Suitable for dynamic data
updates
Answer: b. Slow access for
individual record retrieval
29. Which of the following is
a demerit of the Inverted File Organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Fast access for individual
record retrieval
d. Suitable for applications
with constant data inserts and deletes
Answer: d. Suitable for
applications with constant data inserts and deletes
30. Which is both a merit and
a demerit of the Multiversion Concurrency Control in file organization?
a. Faster access for
individual record retrieval
b. Increased complexity in
addressing and storage management
c. Suitable for applications
with frequent data inserts and deletes
d. No need for an index
table
Answer: b. Increased
complexity in addressing and storage management
31. What is a merit of the
Direct File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Reduced storage space
requirements
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Fast access for
individual record retrieval
32. Which is a merit of the
Bitmap Index in file organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Fast access for individual
record retrieval
Answer: a. Efficient for range
queries
33. What is a demerit of the Multilevel Index
in file organization?
a. Efficient for range
queries
b. Slow access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
34. Which of the following is
a demerit of the Log-Structured Merge Tree (LSM Tree) in file organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Fast access for individual
record retrieval
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Increased
complexity in addressing and storage management
35. Which is both a merit and
a demerit of the Distributed Database in file organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Increased
complexity in addressing and storage management
36. What is both a merit and a
demerit of the Hierarchical File Organization?
a. Efficient for range
queries
b. Fast access for individual
record retrieval
c. Increased complexity in
addressing and storage management
d. Suitable for applications
with constant data inserts and deletes
Answer: c. Increased
complexity in addressing and storage management
37. What is a merit of the
Extensible Hashing in file organization?
a. Efficient for range
queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Fast access for individual
record retrieval
Answer: d. Fast access for
individual record retrieval
38. Which is a merit of the
Replication in distributed databases?
a. Improved efficiency for
range queries
b. Increased complexity in
addressing and storage management
c. Enhanced fault tolerance
and availability
d. Reduced storage space
requirements
Answer: c. Enhanced fault
tolerance and availability
39. What is a demerit of the
Trie Data Structure in file organization?
a. Suitable for applications
with constant data inserts and deletes
b. Increased complexity in
addressing and storage management
c. Fast access for individual
record retrieval
d. Efficient for range
queries
Answer: b. Increased
complexity in addressing and storage management
40. Which of the following is
a demerit of the Linear Hashing in file organization?
a. Fast access for individual
record retrieval
b. Increased complexity in
addressing and storage management
c. Efficient for range
queries
d. Suitable for applications
with constant data inserts and deletes
Answer: b. Increased
complexity in addressing and storage management
41. Which is both a merit and
a demerit of the Dynamic Clustering File Organization?
a. Improved efficiency for
range queries
b. Increased complexity in
addressing and storage management
c. Reduced storage space
requirements
d. Faster access for
individual record retrieval
Answer: a. Improved efficiency
for range queries
42. What is both a merit and a
demerit of the Cyclic Redundancy Check (CRC) in file organization?
a. Increased complexity in
addressing and storage management
b. Efficient for range
queries
c. Reduced storage space
requirements
d. Fast access for individual
record retrieval
Answer: a. Increased
complexity in addressing and storage management
===========================================================
===============
0 Comments