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:

Stockholders' Equity

The residual interest in the assets of a company after deducting liabilities, essentially representing ownership interest.

Expense Accounts

Accounts in the general ledger that are used to record various costs and expenses incurred by a business.

Revenue Accounts

Accounts that track the income a business receives from its various activities, such as sales of products or services.

Loss Accounts

Accounts used to record the loss in value of assets or to represent expenses that reduce net income.