Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q571: What type of storage is lost when power is turned off?
- A: Non-volatile storage
- B: Volatile storage
- C: Flash memory
- D: Magnetic disk
View Answer
B
Q572: Which of the following is a characteristic of physical storage media?
- A: Speed of access
- B: Power consumption
- C: Number of drives
- D: Operating system compatibility
View Answer
A
Q573: What is a common use for flash memory?
- A: Data backup
- B: Battery-powered devices
- C: Main memory
- D: Disk caching
View Answer
B
Q574: How does disk caching improve performance?
- A: By using high-speed SRAM
- B: By increasing main memory capacity
- C: By storing frequently accessed data in a memory buffer
- D: By encrypting data
View Answer
C
Q575: What is the purpose of RAID-0?
- A: Provides fault tolerance
- B: Stripes data for higher throughput
- C: Mirrors data for redundancy
- D: Uses error correction codes
View Answer
B
Q576: RAID-1 is also known as:
- A: Striping
- B: Mirroring
- C: Parity
- D: Error Correction
View Answer
B
Q577: Which RAID level distributes parity among drives?
- A: RAID-1
- B: RAID-2
- C: RAID-3
- D: RAID-5
View Answer
D
Q578: What is a key advantage of RAID-5 over RAID-4?
- A: Faster read speeds
- B: Lower cost per megabyte
- C: Higher fault tolerance
- D: Better write performance
View Answer
B
Q579: What kind of caching uses high-speed SRAM instead of DRAM?
- A: Disk caching
- B: Memory caching
- C: Flash caching
- D: Magnetic caching
View Answer
B
Q580: A memory cache that is built into the architecture of microprocessors is referred to as:
- A: Level 1 (L1) cache
- B: Level 2 (L2) cache
- C: External cache
- D: Disk cache
View Answer
A