Which of the following will CREATE a table with exactly one multi-column index?

Question

Options

• ACREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id), INDEX
• BCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id), INDEX(name) )
• CCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id, name) )
• DCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id,name) )
• EAn index cannot be made to extend across multiple columns.

• A
  3% (2)
• B
  7% (4)
• C
  80% (47)
• E
  10% (6)

No community discussion yet for this question.