View Management Flashcards

7 cards from real SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 View Management flashcards as text

Which system catalog/view commonly lists all views in a database?
Answer: INFORMATION_SCHEMA.VIEWS
INFORMATION_SCHEMA.VIEWS exposes metadata about defined views.
A DELETE issued through an updatable single-table view will affect what?
Answer: Rows in the underlying base table
DML on an updatable view propagates to the underlying base table rows.
Which is a disadvantage of materialized views compared to regular views?
Answer: Data can become stale until refreshed
Because results are cached, materialized views may show outdated data between refreshes.
What does an inline view refer to in SQL?
Answer: A subquery used in the FROM clause
An inline view is a subquery in the FROM clause acting as a temporary view.
To grant another user SELECT access on a view, you use which statement?
Answer: GRANT SELECT ON view_name TO user
GRANT SELECT ON the view name gives read privileges to a user.
Using a view to expose computed columns (like price * quantity) is an example of what?
Answer: Encapsulating business logic
Views can present derived/calculated columns, hiding the computation from users.
Which is TRUE about a standard (non-materialized) view's storage?
Answer: It stores only the query, not the data
A regular view is virtual and stores just the defining SELECT statement.