Structure of the CUSTOMERS table

-Based on the structure of the CUSTOMERS table,which of the following is a valid SQL statement?
A) CREATE PUBLIC INDEX customers_name_idx ON customers (lastname,firstname);
B) CREATE PUBLIC INDEX customers_name_idx ON customers (lastname);
C) CREATE INDEX customers_name_idx ON customers (lastname,firstname);
D) CREATE PUBLIC INDEX customers_name_idx FOR customers (lastname);

Question

Structure of the CUSTOMERS table
  ​
-Based on the structure of the CUSTOMERS table,which of the following is a valid SQL statement?​
A) ​CREATE PUBLIC INDEX customers_name_idx ON customers (lastname,firstname); 
B) ​CREATE PUBLIC INDEX customers_name_idx ON customers (lastname); 
C) CREATE INDEX customers_name_idx ON customers (lastname,firstname);​ 
D) ​CREATE PUBLIC INDEX customers_name_idx FOR customers (lastname);

Quizplus · Accepted Answer

Option C is a valid SQL statement as it creates an index named "customers_name_idx" on the "lastname" and "firstname" columns of the "CUSTOMERS" table. Option A and D are incorrect because they use "CREATE PUBLIC INDEX" instead of "CREATE INDEX". Option B is correct for creating an index on the "lastname" column only, but not on "firstname" column.

Structure of the CUSTOMERS Table