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.
A.LONG VARCHAR, SMALLINT, NUMBER, BLOB B.DECIMAL, DATE, DBCLOB, INTERVAL C.NUMERIC, TIMESTAMP, BYTE, FLOAT D.NUM, TIME, XML, DOUBLE
A.Check B.Range C.Referential D.Informational
微信掃一掃關(guān)注公眾號后聯(lián)系客服
微信掃碼免費(fèi)搜題
