Home › GATE CSE › computerscience › Database Management Systems › A schema is best described, in the menu analogy,…
A schema is best described, in the menu analogy, as
Atonight's special dish on the chalkboard
Bthe price the customer paid at the counter
Cthe shape every dish must fit (main course = name + price)
Dthe eviction policy the kitchen uses for stale dishes
Answer & Solution
Correct answer: C. the shape every dish must fit (main course = name + price)
The menu lists what is allowed, not what is being served right now. A schema is an agreement on shape (what columns exist and of what type), not the actual rows. Tonight's special is data, not schema; the price paid is a row value; eviction policy belongs to the buffer pool, not the schema.
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