下面的语句按顺序成功执行后 CREATE TABLE tab1 （c1 CHAR（1)) INSERT INTO tab1 VALUES （'b') CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 ='a' INSERT INTO view1 VALUES （'a') INSERT INTO tab1 VALUES （'b') 执行SELECT

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

The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;（）

A.4

B.3

C.1

D.0

Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY5 Europe 6 North America 7 South AmericaWhich of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）

A.INSERT INTO tab1 SELECT cx, cy FROM tab2

B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)

D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

向表中插入数据的SQL语句是

A．INSERT

B．INSERT INTO

C．INSERT BLANK

D．INSERT BEFORE

向表中插入数据的SQL语句是______。

A．INSERT

B．INSERT BEFORE

C．INSERT BLANK

D．INSERT INTO

向表中插入数据的SQL语句是______。

A．INSERT

B．INSERT BEFORE

C．INSERT BLANK

D．INSERT INTO

有如下SQL语句：INSERT INTO职工VALUES(”WH4”，”E15”，张清",2800)在命令窗口执行该命令后（ ）。

A)向表中任意位置插入一条新记录

B)在当前记录之前，插入一条新语句

C)在当前记录之后，插入一条新语句

D)在表末尾新增一条记录

有下列SQL语句：

INSERT INTO 职工 VALUES("WH4","E15","张清",2800) 在命令窗口执行该命令后( )。

A．向表中任意位置插入一条新记录

B．在当前记录之前，插入一条新语句

C．在当前记录之后，插入一条新语句

D．在表末尾新增一条记录

有下列SQL语句： INSERT INTO职工 VALUES("WH4","E15","张清",2800) 在命令窗口执行该命令后( )。

A．向表中任意位置插入一条新记录

B．在当前记录之前，插入一条新语句

C．在当前记录之后，插入一条新语句

D．在表末尾新增一条记录

下列SQL 语句中，用于修改表结构的是

A．ALTER

B．CREATE

C．UPDATE

D．INSERT