单项选择题

Given the following DDL and INSERT statements: CREATE V……

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

单项选择题Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）

A.3
B.2
C.1
D.0

单项选择题A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）

A.Alias
B.View
C.Schema
D.Trigger