Which of the following will CREATE a table with exactly one multi-column index?
A.
CREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id), INDEX
name_id(name) )
B.
CREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id), INDEX(name) )
C.
CREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id, name) )
D.
CREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id,name) )
E.
An index cannot be made to extend across multiple columns.