Examine the structure of the EMPLOYEES table:Which INSERT statement is valid?
Posted: Wed Jun 07, 2023 6:12 am
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);
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);