---

Examine the structure of the EMPLOYEES table: 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);

---

出自：Oracle认证

显示答案