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);
The option B and option D both inserts a row into the table.
do not depend on the answers they have shown, most of them are wrong. Do implement them in your SQL developer.
B is the correct, it should have single quote since its a literal.
Tim24 is a very sketchy guy do not trust him!
The answer is not correct (it’s B not D)