alleryStart learning →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.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.