Practice Flashcards
Flip to reveal answersWhat is a database view?
Track your progress — Sign up free to save your progress and get smart review reminders based on spaced repetition.
All 5 Flashcards — Database views
Sign up free to track progress and get spaced-repetition review schedules.
Question
What is a database view?
Answer
A **stored query with a name**, used like a table. It holds **no data of its own**.
Question
Why is a view always up to date?
Answer
It stores the **query**, not the result, so every read runs it afresh — there is nothing to go stale.
Question
How does a view provide security?
Answer
Grant rights on the **view only**. With no permission on the underlying table, a user cannot reach a column the view does not select.
Question
Does a view make a query faster?
Answer
**No.** The underlying query runs on every read. A **materialised view** stores the result and is fast, but is only current to the last refresh.
Question
Can you update through a view?
Answer
Sometimes — a simple view over one table often yes. One with a **join, GROUP BY or aggregate** usually not: there is no single underlying row to change.
Read the notes
Full study notes for Database views
Topic 3.3 hub
Database programming
More from Topic 3.3
All flashcards in this topic
Computer Science exam skills
Paper structures & tips
Track your progress with spaced repetition
Sign up free — Aimnova tells you exactly which cards to review and when, so you remember everything before your IB exam.
Start Free