Tcmg 316 Quiz Review 127 Correctly Answered Questions Latest Update

Select count(*) from a database table will return he number of records contained in the table. {Ans: True}DDL stands for Data Definition Language and is used to work with objects within the database. {Ans: True}Which of the following statements best describes what this INSERT statement does? INSERT INTO invoices_copy SELECT *FROM invoices WHERE terms_id = 1 {Ans: Adds all of the rows in the Invoices table that have 1 in the terms_id column to the Invoices_Copy table}Which of the following is not a common API: {Ans: DCCM}Which of the following expressions does not compute 10% of the balance due if balance due is the invoice total minus the credit total minus the payment total? {Ans: invoice_total - credit_total - payment_total / 10}Which of the following statements would you use to change the invoice_total value in the Invoices table so it's 1% less than the current invoice total for every vendor in the state of Arizona? {Ans: . UPDATE invoices SET invoice_total = invoice_total - (invoice_total * .01) WHERE vendor_id IN (SELECT vendor_idFROM vendorsWHERE vendor_state = 'AZ')}