Please tell me the answer for the below question, if you are sure about it.

With DBADM authority on the database and given the statements:
CREATE TABLE t1 (c1 CHAR(1))
INSERT INTO t1 VALUES ('b')
CREATE VIEW v1 AS SELECT c1 FROM t1 WHERE c1 ='a'
INSERT INTO v1 VALUES ('a')
INSERT INTO v1 VALUES ('b')
How many rows would be returned from the statement, SELECT c1 FROM t1?

Thanks,

Hi,
2 rows, because 'create view' is not specified 'with check option'.

Tip: if you would like to learn something about DB2 try executing your commands to DB2 database and then check the result.

Hope this helps,
Grofaty

Thanks for your reply

3 rows are returned. The final SELECT goes against the underlying table and not the view.

I think you are correct Stolze. And also in case if WITH CHECK option is specified, the last INSERT will fail right?

@stolze, I have overlooked v1, t1 names so similar... Thanks for info.
@Joseph_T, if which check is specified the last insert will fail.