A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?()

A . Any row inserted or updated through view V1 must meet the condition that col4 > 1000. B . From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked. C . At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected. D . Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.

时间:2022-08-31 05:12:15 所属题库:IBM(000-730)题库

相似题目