多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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);
正确答案:E
答案解析:
进入题库查看解析

微信扫一扫手机做题