试题详情
单项选择题 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);

  • 关注下方微信公众号，在线模考后查看

热门试题