Information Technology > QUESTIONS & ANSWERS > Skill_1.4_Quiz.docx.pdf (All)

Skill_1.4_Quiz.docx.pdf

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 Correct Answer: This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 13:41:48 GMT -05:00 https://www.coursehero.com/file/74765731/Skill-14-Quizdocx/d) SELECT * INTO CustHist FROM Customer  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  Question 6 4 out of 4 points Which rows will be updated when the following query executes Selected Answer: b) Only employees with both EmpBonus equal ‘Yes’ or EmpSalary greater than 124999 Correct Answer: b) Only employees with both EmpBonus equal ‘Yes’ or EmpSalary greater than 124999 [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: