When will DB2 access the data from table T1 for view V1?

A view is created with the following statement:
CREATE VIEW v1
AS SELECT col1, col2, col3
FROM t1
WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?
A. When view V1 is created
B. Each time the REFRESH VIEW v1 statement is executed
C. Each time an SQL statement is executed against view V1
D. Only the first time an SQL statement is executed against view V1

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.