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)
|
Download Printable PDF. VALID exam to help you PASS. |
 |