PrepAway - Latest Free Exam Questions & Answers

Which of the following INSERT statements will fail?

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?

PrepAway - Latest Free Exam Questions & Answers

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)

2 Comments on “Which of the following INSERT statements will fail?


Leave a Reply