Home › GATE CSE › computerscience › Database Management Systems › Plain (non-materialized) SQL views
Plain (non-materialized) SQL views
Astore a copy of the result, refreshed every minute by default
Bare syntactic sugar for temporary tables created at session start
Cdo not store a copy; each SELECT re-runs the query
Dexist only in the application layer, not in the DBMS
Answer & Solution
Correct answer: C. do not store a copy; each SELECT re-runs the query
Plain views are virtual: the view definition is stored, but the result is computed on demand by re-running the query against the live base tables. Materialized views, in DBMSs that support them, do store a copy and refresh on a schedule. The plain kind is the default in standard SQL.
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