C2090-730 practice

Q3 Single choice

If the following statement is executed:

CREATE TABLE employee
(empid INT NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 5),
name VARCHAR(20),
dept INT CHECK (dept BETWEEN 1 AND 20),
hiredate DATE WITH DEFAULT CURRENT DATE,
salary DECIMAL(7,2),
PRIMARY KEY(empid),
CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR
Salary > 60500));

Which of the following INSERT statements will fail?

A
INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
B
INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
C
INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
D
INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)