What Does the Following SQL Statement Do

question 81

Multiple Choice

What does the following SQL statement do?
Select * From Customer Where Cust_Type = "Best"

• A) Selects all the fields from the Customer table for each row with a customer labeled "best"
• B) Selects the "*" field from the Customer table for each row with a customer labeled "best"
• C) Selects fields with a "*" in them from the Customer table
• D) Selects all the fields from the Customer table for each row with a customer labeled "*"

---

Definitions:

Dividends

Earnings distributed by a company to its shareholders, usually in the form of cash or additional shares.

Consolidated Retained Earnings

The total accumulated profits of a parent company and its subsidiaries after dividends are paid, as shown in consolidated financial statements.

Equity Method

An accounting practice where an investor records its proportional share of investee profits or losses, reflecting the changing value of its investment over time.

Consolidated Net Income

The total net income of a parent company and its subsidiaries after removing the effects of intercompany transactions.