Computer Science > Quiz > SKILLS QUIZ (All)

SKILLS QUIZ

Document Content and Description Below

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 dat... atypes. 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]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: