CIW Exam Questions

Which of the following SQL statements would properly add information for a new employee?

Consider the relation shown in the exhibit.

Which of the following SQL statements would properly add information for a new employee?

A.
INSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);

B.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);

C.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);

D.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);