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:

Credit Sales

Sales made by a business where payment is delayed, allowing the buyer to purchase goods or services on credit.

Direct Method

A way of reporting cash flows from operating activities that lists major categories of gross cash receipts and gross cash payments.

Depreciation Expense

The distribution of a physical asset's cost throughout its lifespan.

Operating Activities

Business actions that are part of a company's primary operations, including revenue generation and expenses tied to its core business functions.