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)

Question

Quizplus · Accepted Answer

The correct command to create a new table named CustState containing only the fields CustomerNum and State from the Customer table is to use the PROJECT operation. This operation selects specific columns from an existing table to create a new table.

Based on the Table Below, Which Command Creates a New