Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q581: Which RAID level uses byte-level striping across several drives?
- A: RAID-0
- B: RAID-1
- C: RAID-3
- D: RAID-4
View Answer
C
Q582: What is a common feature of optical disks?
- A: They use magnetic encoding
- B: They can be erased and rewritten multiple times
- C: They use lasers to read and write data
- D: They are the fastest type of storage
View Answer
C
Q583: What type of access does a magnetic tape device provide?
- A: Random access
- B: Sequential access
- C: Direct access
- D: Parallel access
View Answer
B
Q584: What is the main benefit of using a fixed-size record structure in file organization?
- A: Ease of adding records
- B: Ease of searching records
- C: Batch processing of the entire file
- D: Ease of deleting records
View Answer
C
Q585: What is the key characteristic of a sequential file organization?
- A: Records can be accessed randomly
- B: Records are ordered by a key field
- C: Records are stored in an indexed format
- D: Records are not stored in any particular order
View Answer
B
Q586: What type of file organization uses an index to improve search speed?
- A: Sequential file organization
- B: Direct file organization
- C: Indexed sequential file organization
- D: Relative file organization
View Answer
C
Q587: How does indexed sequential file organization speed up key searches?
- A: By performing a linear search across all records
- B: By using a single-level index to locate records
- C: By storing records in a random order
- D: By reducing the size of the records
View Answer
B
Q588: In indexed sequential file organization, what is typically used to mark intervals of data records?
- A: Key-pointer pairs
- B: A direct file pointer
- C: An index file
- D: Sequential record numbering
View Answer
C
Q589: Which type of index contains an entry for each record in the main file?
- A: Dense index
- B: Partial index
- C: Secondary index
- D: Sparse index
View Answer
A
Q590: In a file with 1,000 records, how many key comparisons are needed on average using a sequential organization?
- A: 100
- B: 500
- C: 1000
- D: 200
View Answer
B