If the following statements are executed in the order shown: Which statement is true?
A.
The REFRESH TABLE statement must be executed before insert, update, and delete
operations performed against table TAB1 will be seen intable TAB2.
B.
Insert, update, and delete operations performed against table TAB1 are automatically
cascaded to table TAB2.
C.
Data stored in table TAB1 is automatically copied to table TAB2 immediately after table
TAB2 is created.
D.
Insert, update, and delete operations can be performed against table TAB2.
DATA INITIALLY DEFERRED clause
DB2 does not populate the materialized query table when you create the table. You must explicitly populate the materialized query table.
For system-maintained materialized query tables, populate the tables for the first time by using the REFRESH TABLE statement.
For user-maintained materialized query tables, populate the table by using the LOAD utility, INSERT statement, or REFRESH TABLE statement.
0
0
MAINTAINED BY SYSTEM clause
Specifies that the materialized query table is a system-maintained materialized query table. You cannot update a system-maintained materialized query table by using the LOAD utility or the INSERT, UPDATE, MERGE, TRUNCATE, or DELETE statements. You can update a system-maintained materialized query table only by using the REFRESH TABLE statement. BY SYSTEM is the default behavior if you do not specify a MAINTAINED BY clause.
0
0