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

Question

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

Quizplus · Accepted Answer

The correct syntax for creating an index is:
CREATE INDEX index_name ON table_name (column_name);
Option A and C are incorrect because "retail-cost" is not a valid column name, and the keyword "FOR" should be "ON". Option D is incorrect because the function INITCAP() is not supported by all database systems. Therefore, option B is the only valid SQL statement for creating an index on the BOOKS table.

Structure of the BOOKS Table