Examine the structure of the EMPLOYEES table:
Which INSERT statement is valid?
A.
INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith,
,,01/01/01);
B.
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith,
01 January 01);
C.
INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES ( 1000, ,,John, ,,Smith,
To_date(,,01/01/01));
D.
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000, ,,John, ,,Smith,
01-Jan-01);
Explanation:
It is the only statement that has a valid date; all other will result in an error.
Answer A is incorrect, syntax error, invalid date format