1D0-441 practice - PrepKeys

Q4 Single choice

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 INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
C
INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
D
INSERT INTO Employee (Emp_ID, First_Name, Last_Name, Birth_Date) VALUES (0005, Tim, Bogart, 03-05-77);