试题详情
- 单项选择题 Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER 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);
关注下方微信公众号，在线模考后查看
热门试题
- You would like to di
- The ORDERS table ha
- Examine the structu
- Which is an iSQL*Plu
- Which four are attri
- Examine the data fr
- Which four statement
- What is true of usin
- The EMPLOYEES table
- Which three statemen
- Evaluate this SQL s
- Which two statements
- Exhibit TheCOMMISSI
- You need to produce
- Which two are attrib
- Examine the structu
- Which two statements
- The EMPLOYEES table
- The EMPLOYEES table
- Which three SELECT s