根据《劳动防护用品监督管理规定》，检测检验机构出具虚假证明，尚不够刑事处罚的，由安全生产监督管

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

SQL的DDL语句不包括()

A、SELECT

B、CREATE TABLE

C、DROP VIEW

D、DROP INDEX

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE (id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement？

A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

A、all server | database

B、table | view

C、all server | table

D、database| table

A、create table

B、update

C、drop table

D、alter table

A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100),job CHAR(10) CHECK (job IN (‘Sales‘,‘Mgr‘,‘Clerk‘)), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) );Which of the following INSERT statements will fail？（）

A.INSERT INTO employee VALUES (2, ‘Smith‘, 80, ‘Mgr‘, ‘09/03/2006‘, 80000, NULL)

B.INSERT INTO employee VALUES (4, ‘Smith‘, 86, ‘Mgr‘, ‘07/14/2003‘, 90000, NULL)

C.INSERT INTO employee VALUES (1, ‘Smith‘, 55, ‘Sales‘, ‘07/14/2003‘, NULL, NULL)

D.INSERT INTO employee VALUES (3, ‘Smith‘, 33, ‘Analyst‘, ‘11/26/2006‘, 90000, NULL)

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

A、CREATE TABLE

B、CREATE SESSION

C、CREATE ANY TABLE

D、UNLIMITED TABLESPACE