【单选题】
Examine the structure of the EMPLOYEES table:<br /> Column name Data type Remarks<br /> EMPLOYEE_ID NUMBER NOT NULL, Primary Key<br /> LAST_NAME VARCNAR2(30)<br /> FIRST_NAME VARCNAR2(30)<br /> JOB_ID NUMBER<br /> SAL NUMBER<br /> MGR_ID NUMBER References EMPLOYEE_ID column<br /> DEPARTMENT_ID NUMBER<br /> You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）
A、CREATE INDEX NAME _IDX (first_name, last_name);
B、CREATE INDEX NAME _IDX (first_name, AND last_name)
C、CREATE INDEX NAME_IDX ON (First_name, last_name);
D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
查看正确答案
