A dynamic view is one whose contents materialize when referenced.

Solution (By Examveda Team)

Option B: False - This option is correct. In SQL, a dynamic view is one that does not materialize its contents when referenced. Instead, it executes the underlying query or queries each time it is referenced, ensuring that the view always reflects the current state of the underlying data. This contrasts with a materialized view, which stores the result set of the query and requires explicit refreshing to update its contents.

Option A: True - This option is incorrect. A dynamic view does not materialize its contents; instead, it executes its query or queries each time it is referenced.

Conclusion:
The statement "A dynamic view is one whose contents materialize when referenced" is Option B: False. Therefore, the correct answer is False.