Solved

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)

Correct Answer:

verifed

Verified

Related Questions