table structure for Customer
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
...
table structure for Customer
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
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
Question 7
4 out of 4 points
Which query will delete rows from the customer table that do not have an
order in the order table. Assume CustID column is the join column for each
table
Selected
[Show More]
