What is a materialized view and what are the advantages of a maintaining a materialized view rather than using the view resolution process?
What will be an ideal response?
Materialized view is a temporary table that is stored in the database to represent a view, which
is maintained as the base table(s) are updated.
Advantages - may be faster than trying to perform view resolution.
- may also be useful for integrity checking and query optimisation.
You might also like to view...
If you select a state and change the image by accident, you can use the ____ command on the Edit menu to restore the eliminated states.
a. Undo b. Redo c. Fix d. Restore
Identify and explain the functions of the three PowerShell ISE panes.
What will be an ideal response?
A(n) ________ is an image that represents facial expressions
A) photo B) file C) emoticon D) link
Which of the following is not a characteristic of a computer worm?
A. Self-replicating B. Usually standalone executable programs C. Self-distributing D. Spread through a process called side-loading