Which of the Following SQL Commands Creates an Index Named

question 26

Multiple Choice

Which of the following SQL commands creates an index named LastName on the LastName field in the Customers table?

• A)CREATE INDEX LastName, Customers.LastName;
• B)CREATE INDEX LastName;
• C)SELECT LastName FROM Customers INDEX LastName
• D)CREATE INDEX LastName ON Customers (LastName);

---

Definitions:

Musical Rhyming

The creation of music through the use of rhymes, often found in lyrics, enhancing memorability and aesthetic appeal.

Fan Effect

is a phenomenon observed in cognitive psychology where the time taken to retrieve information from memory increases as the amount of related information increases.

Retrieval

The processes by which stored information is brought back to conscious awareness.

Information Overflow

Information overflow, often called information overload, occurs when an individual receives too much information, making it difficult to process or make decisions.