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…

The correct answer is E. CREATE INDEX NAME_IDX. Answer E provides correct syntax to create index: CREATE INDEX index_name ON table_name(list of columns). Incorrect Answers A: You need to use keyword ON also to create index. B: You cannot use keyword AND to build a list of columns for index. Also this statement is missing the…

Creating and Managing Schema Objects

Question

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?

Exhibit

Options

ACREATE INDEX NAME_IDX (first_name, last_name);
BCREATE INDEX NAME_IDX (first_name AND last_name);
CCREATE INDEX NAME_IDX
DCREATE INDEX NAME_IDX
ECREATE INDEX NAME_IDX
FCREATE INDEX NAME_IDX

How the community answered

(30 responses)

A
10% (3)
B
3% (1)
D
3% (1)
E
80% (24)
F
3% (1)

Explanation

Answer E provides correct syntax to create index: CREATE INDEX index_name ON table_name(list of columns). Incorrect Answers A: You need to use keyword ON also to create index. B: You cannot use keyword AND to build a list of columns for index. Also this statement is missing the table name on which the index is creating. C: This statement is missing the table name on which the index is creating. D: You cannot use keyword AND to build a list of columns for index. F: You cannot use keyword FOR to create an index.

Topics

#CREATE INDEX#composite index#index syntax#ON clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice