Quiz 5 - Chapter 5 DueOct 8, 2022 at 11:59pmPoints20Questions10 AvailableOct 1, 2022 at 12am - Oct 11, 2022 at 11:59pmTime LimitNone Allowed Attempts3 Instructions This quiz was locked Oct 11, 2022 at 11:59pm. Attempt History AttemptTimeScore KEPTAttempt 23 minutes20 out of 20 LATESTAttempt 23 minutes20 out of 20 Attempt 116 minutes18 out of 20 Answers will be shown after your last attempt Score for this attempt:20 out of 20 Submitted Oct 4, 2022 at 11:49am This attempt took 3 minutes. Quiz 5 - Chapter 5 2 / 2 pts Question 1 Which of the following statements is true when you use MySQL Workbench to run INSERT, UPDATE, and DELETE statements? By default, the changes are automatically committed to the database. 3/8/23, 11:55 AMQuiz 5 - Chapter 5: PC 2022 FALL-CIS276DA 18743 https://learn.maricopa.edu/courses/1250108/quizzes/3366772?module_item_id=265247232/7If autocommit mode is on, you can rollback the changes by clicking on the Rollback button. If autocommit mode is on, you can commit the changes by clicking on the Commit button. By default, the changes are rolled back when you exit MySQL Workbench unless you commit them. 2 / 2 pts Question 2 Assuming that all of the table and column names are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO invoices (vendor_id, invoice_number, invoice_total, payment_total, credit_total, terms_id, invoice_date, invoice_due_date) VALUES (97, '456789', 8344.50, 0, 0, 1, '2012-08-31') The column names in the column list are in the wrong sequence. All of the values should be enclosed by single quotes. There are too many items in the VALUES list. The number of items in the column list doesn't match the number in the VALUES list.
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order Now
Get Online
Assignment Help Services
