Based on the Table Below, Which Command Creates a New

question 2

Multiple Choice

Based on the table below, which command creates a new table named CustState containing the fields CustomerNum and State??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

• A) JOIN Customer WITH (CustomerNum, State) GIVING CustState
• B) PROJECT Customer OVER (CustomerNum, State) GIVING CustState
• C) SELECT Customer OVER (CustomerNum, State) GIVING CustState
• D) MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State)

---

Definitions:

Financial Ratio

A numerical comparison derived from a company's financial statements that investors use to analyze a company's performance.

Shareholders

Individuals, companies, or institutions that own at least one share of a company's stock, and as a result, potentially benefit from its success in the form of dividends and/or capital gains.

Premise Control

The monitoring and management of the physical space or environment in which a business operates to ensure safety and efficiency.

Marketing Plan

A comprehensive document or blueprint that outlines a company’s advertising and marketing efforts for the coming period, detailing strategies for reaching target markets.