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 strin
...
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]
