Main Memory Databases – Real-time Systems MCQs 20 min Score: 0 Attempted: 0/20 Subscribe 1. What is a main memory database (MMDB)? (A) A database that stores data exclusively on disk (B) A database that stores all data in the main RAM for fast access (C) A batch-only database (D) A database for CPU scheduling 2. Which is the main advantage of a main memory database? (A) Disk-based performance exclusively (B) Reduced memory usage automatically (C) Batch file processing only (D) Very low latency and high-speed data access 3. MMDBs are mainly used in: (A) Multimedia streaming exclusively (B) Desktop word processing only (C) Real-time systems, telecommunications, and online transaction processing (OLTP) (D) Batch file storage 4. Which is a key feature of main memory databases? (A) Uses batch disk writes exclusively (B) Only stores metadata (C) Entire dataset resides in RAM, minimizing disk I/O (D) Ignores time-critical operations 5. How do MMDBs achieve high performance? (A) By increasing CPU idle time (B) By reducing disk access and accessing data directly from main memory (C) By batch file processing exclusively (D) Disk-only caching 6. Which type of durability mechanism is commonly used in MMDBs? (A) Memory-only logging (B) CPU idle logging only (C) Batch disk writes exclusively (D) Transaction logging or periodic checkpointing 7. What is a major challenge of main memory databases? (A) Volatility of RAM leading to data loss during power failure (B) Slow disk access (C) Random CPU cycles only (D) Batch-only scheduling 8. Which of the following can improve MMDB reliability? (A) Disk fragmentation management (B) CPU-only optimization (C) Batch processing exclusively (D) Non-volatile memory, replication, or logging mechanisms 9. Main memory databases are particularly suitable for: (A) Desktop computing only (B) Batch-only systems (C) Disk-bound archival storage exclusively (D) Applications requiring real-time responses and low latency 10. Which query performance advantage do MMDBs have over disk-based databases? (A) Disk scheduling exclusively (B) CPU idle only (C) Significantly faster query execution due to in-memory access (D) Batch transfer 11. Which type of storage structure is common in MMDBs? (A) Main memory optimized indexes and data structures (B) Disk-based B-trees only (C) CPU cycle tables exclusively (D) Batch file storage 12. How do MMDBs handle transaction consistency? (A) Only batch disk writes (B) Using in-memory concurrency control and logging mechanisms (C) CPU idle scheduling exclusively (D) Memory-only snapshots 13. Which of the following is a real-time database requirement that MMDBs satisfy well? (A) Batch file optimization only (B) Low-latency response to time-critical queries (C) Disk-based archival exclusively (D) CPU idle monitoring 14. MMDBs reduce which of the following performance bottlenecks? (A) Batch file processing (B) CPU idle exclusively (C) Memory allocation only (D) Disk I/O latency 15. Which mechanism ensures durability in volatile main memory databases? (A) Transaction logging to disk and checkpointing (B) CPU idle logging only (C) Random memory snapshots exclusively (D) Disk batch writes only 16. MMDBs are often used in which domains? (A) Batch multimedia streaming (B) Desktop office applications exclusively (C) Telecommunications, financial systems, real-time control (D) Disk archival only 17. Which type of indexing is commonly optimized for MMDBs? (A) CPU idle tables exclusively (B) Disk-only B-trees (C) In-memory B-trees and hash indexes (D) Batch file indexes 18. A major trade-off of MMDBs is: (A) Slow disk access only (B) High memory requirement and potential data loss without proper logging (C) CPU overload exclusively (D) Batch processing overhead 19. MMDBs can improve real-time system performance by: (A) Providing instant access to frequently updated data (B) Batch-only processing (C) Disk-based archival exclusively (D) CPU idle monitoring only 20. The main advantage of main memory databases in real-time systems is: (A) Batch file transfer only (B) Fast, predictable, and low-latency data access for time-critical applications (C) CPU idle monitoring exclusively (D) Disk storage optimization only Related Posts:Shared Memory vs Distributed Memory MCQsDifference Between Primary Memory and Secondary MemoryTemporal Databases - Real-time Systems MCQsList of Journals on information systems and databasesMain navigation areas MCQs on Peach TreeMCQs Verbs (main/auxiliary, transitive/intransitive, finite/non-finite)
