问题

A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL n

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)

参考答案

您可能感兴趣的试题

以F的SQL语句中，（）语句用于创建表。 A)CREATE TABLEB)CREATE INDEXC)ALTERR TABLED)DRop

答案解析
On the table was a vase filled with artificial

答案解析
On the table was a vase filled with artificial

答案解析
Given the following requirements:Create a table named TESTTAB which has an identity colum

答案解析
Given the following requirements:Create a table to contain employee data with a unique nu

答案解析
Which of the following sequence of commands extracts the third image from a tape that was created using the backup command?()

答案解析