Structure of the CUSTOMERS Table

Multiple Choice

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