Structure of the BOOKS Table

question 136

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);