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);
No, the answer is wrong here.
A is invalid
B is correct if you use ’01 january 01′ instead of 01 january 01
C is invalid
D is correct if you use ’01-jan-01′ instead of 01-jan-01