Information Technology > Quiz > A valid Insert statement (All)

A valid Insert statement

Document Content and Description Below

A valid Insert statement uestion 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 Correct Answer:  Question 4 4 out of 4 points Assume we have a table Employees with a column named Salary. Which of the following will give everyone a 10% raise? Selected Answer: c) UPDATE Employees SET Salary = Salary + (Salary * .10) Correct Answer: c) UPDATE Employees SET Salary = Salary + (Salary * .10)  Question 5 4 out of 4 points What will be the output of the following query Selected Answer: d) The old values of Bonus and Salary then the new values of Bonus and Salary Correct Answer: d) The old values of Bonus and Salary then the new values of Bonus and Salary [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: