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:

Verified
Correct Answer:
Verified
Q1: When both criteria must be true for
Q2: To select data from more than one
Q3: Explain what relational algebra is and how
Q4: A _ primary key is composed of
Q7: Which command contains all rows that are
Q8: Which command creates a table containing all
Q9: Which operator is used to concatenate every
Q10: Which of the following is NOT true
Q11: Multiple entries in tables are often called
Q20: What type of functions are Count, Sum,