🎴 Flashcard Mode

Oracle Database Administration and PL/SQL

Card1 / 20
Mastered0
Review0
QuestionClick to flip

When does a view get populated?

AnswerClick to flip back
A
Any time an executable SQL statement references it
💡 Explanation:

A view is a virtual table that stores only a query definition, not data. Every time an executable SQL statement references the view, the underlying query executes to produce the result set dynamically - the view is repopulated on each reference.

Change Mode