Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE 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:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
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');

1Z0-007