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
You are here: Home > IBM Questions & Answers > C2090-730 > WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?
WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?
Posted by seenagape on January 2, 2015 Leave a comment (0) Go to comments
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
0
0