1z0-320 Exam Dumps | Which statement would create an index by using the first 10 characters of the name column in the customer

<< Prev Question Next Question >>

Question 18/40

Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?)

A. CREATE SUB INDEX part_of_name ON (customer, name, 10);

B. CREATE INDEX (10) ON (customer.name);

C. CREATE INDEX part_of_name ON customer (name(10));

D. CREATE PARTIAL INDEX part-of_name ON customer (name, 10);

E. CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;

Question 18/40

LEAVE A REPLY

Download PDF File