单项选择题
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
点击查看答案
相关考题
-
单项选择题
Which of the following database objects is considered executable using SQL?()
A.View
B.Table
C.Routine
D.Package -
单项选择题
Which of the following describes the objects of a DB2 database and their relationships?()
A.Instance
B.Table space
C.System catalog
D.Schema repository -
单项选择题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()
A.View
B.Alias
C.Table
D.Package
