可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the structure of the EMPLOYEE


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)
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NA...

2、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert ...

3、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich UPDATE stat...

4、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()ABCD

5、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT 'SA_REP'SAL NUMBERCOMM...

6、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements inserts...