Structure of the CUSTOMERS Table

question 22

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

---

Definitions:

Optimization

The process of making something as fully perfect, functional, or effective as possible within given constraints.

Expressive Action Verbs

Verbs that convey specific, vivid actions or emotional states, enhancing the descriptiveness of a sentence.

Conversational Language

The use of informal, everyday speech in writing or speaking, aiming to make communication more relatable.

Numbers

Numerical symbols or quantities used for counting, measuring, labeling, or calculating.