Question 1 4 out of 4 points Assume the following table structure for Customer: CustID (Primary key), CustLName, CustFName, CustCity, CustState, CustZip. All are required fields and are string datatypes. Which of the fol
...
Question 1 4 out of 4 points Assume the following table structure for Customer: CustID (Primary key), CustLName, CustFName, CustCity, CustState, CustZip. All are required fields and are string datatypes. Which of the following is a valid Insert statement (assume the values match the column name, so ‘CustID’ would go in the CustID column)? Selected Answer: b) INSERT INTO Customer VALUES (‘CustID’, ‘CustLName’, ‘CustFName’, ‘CustCity’, ‘CustState’, ‘CustZip’,) Correct Answer: b) INSERT INTO Customer VALUES (‘CustID’, ‘CustLName’, ‘CustFName’, ‘CustCity’, ‘CustState’, ‘CustZip’,) Question 2 4 out of 4 points Assume the following table structure for Customer: CustID (Primary key), CustLName, CustFName, CustCity, CustState, CustZip. All are required fields and are string datatypes. There is a corresponding table CustHist which contain the same columns. Which of the following inserts data into the CustHist table from the Customer table (assume the values match the column name, so ‘CustID’ would go in the CustID column)? Selected Answer: a) INSERT INTO CustHist SELECT * FROM Customer Correct Answer: a) INSERT INTO CustHist SELECT * FROM Customer Question 3 4 out of 4 points Assume the following table structure for Customer: CustID (Primary key), CustLName, CustFName, CustCity, CustState, CustZip. All are required fields and are string datatypes. Which of the following inserts data into a CustHist table that does not exist from the Customer table (assume the values match the column name, so ‘CustID’ would go in the CustID column)? Selected Answer: d) SELECT * INTO CustHist FROM Customer
[Show More]