Home › GATE CSE › computerscience › Database Management Systems › Per the lecture, which is NOT one of the three p…
Per the lecture, which is NOT one of the three pains a DBMS solves over a flat-file notebook?
Anetwork latency between client and storage layer
Bintegrity (wrong types, missing fields, orphan refs)
Cimplementation (concurrent writers, finding records)
Ddurability (machine crashes during a write)
Answer & Solution
Correct answer: A. network latency between client and storage layer
Network latency is not specific to flat files. The lecture names three failure modes that flat files share: integrity (the data goes bad silently), implementation (no concurrency or fast lookup), durability (crashes lose work). A DBMS exists to absorb all three.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment