热门：

可学答题网 > 问答 > IBM(000-730)题库

目录：标题| 题干| 答案| 搜索| 相关

问题

A table was created using the followi

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?（）

AINSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
BINSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
CINSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
DINSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)

参考答案

参考解析：

分类：IBM(000-730)题库

1、A sequence was created with the DDL st

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully ex...

2、Table TAB1 was creat

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2&#81...

3、The user SYS creates a job by using t

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding comma...

4、A sequence was created with the DDL st

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully execute...

5、When I was a child, I used （） to the r

When I was a child, I used （） to the river and bathe in the evening.Ato goingBto goCgoDgoing

6、The INV_HISTORY table is created usin

The INV_HISTORY table is created using the command:You would like to store the data belonging to the year 2006 in a single partition and issu...

编辑推荐

渣口泥套一般情况下干燥无水，一旦潮湿，则是（）迹象。..

对于债权人而言，公司的股东权益比率高，意味着债权人的权益.....

下列选项中，是金属材料使用物理性能的（）。..

行政执法行为，除了哪三项外，都应予以公示？..

BIM技术在现阶段建筑设计中有哪些应用价值（）。..

关于逆向物流不正确的说法是（）。..