Start learning →

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.
Practise this question with Quill — GATE CSE →

Keep practising Database Management Systems

Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.

Start a Database Management Systems lesson →
Related questions
Database concepts bingoWhich ones belongSpot the false statementRows or columnsWhich one does not belongCandidate or primary keyOrder the case for a DBMSOne word is wrong