【单项选择题】
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 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? （）<p> 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 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? （）</p>
A、A. CREATE INDEX NAME _IDX (first_name, last_name);
B、B. CREATE INDEX NAME _IDX (first_name, AND last_name)
C、C. CREATE INDEX NAME_IDX ON (First_name, last_name);
D、D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E、E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F、F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
查看正确答案
