Structure of the BOOKS Table

Multiple Choice

Structure of the BOOKS table
​
-Based on the structure of the BOOKS table,which of the following is a valid SQL statement?​

A) ​CREATE INDEX books_profit_idx
ON books "retail-cost";
B) CREATE INDEX books_title_idx
ON books (INITCAP(title) ) ;​
C) ​CREATE INDEX books_profit_idx
FOR books "retail-cost";
D) ​CREATE INDEX books_title_idx
FOR books (INITCAP(title) ;