首页 文档 GiventhefollowingDDLandINSERTstatements:CREATEVIEWv1

GiventhefollowingDDLandINSERTstatements:CREATEVIEWv1

Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?()

A.0

B.1

C.2

D.3

参考答案:C

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/bk/wd-bk/409105.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部