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);
Examine the structure of the EMPLOYEES table:Which INSERT statement is valid?
-
- Site Admin
- Posts: 899566
- Joined: Mon Aug 02, 2021 8:13 am