Question

Form A Mid-Term Exam In ajoin, when using the ON keyword, column names need to be qualified only A in inner joins B. in outer joins c when the code is confusing D. when the same column names exist in both tables 7. Referring to the following code example and the data model the total number of rows returned by this query must equal SELECT vendor name, Invoice number FROM invoices LEFT JOIN vendors ON Invoices. vendor id = vendors.vendor id A the number of rows in the Invoices table B. the number of rows in the Vendors table c the number of rows in the Invoices table plus the number of rows in the Vendors table D. none of the above Invoices involo INT(11) vendor INT(11) vorum VARCHAR(5) DATE involont DECIMALE92) payment to DECIMAL,2) aedo DECIMAL(9,2) terms INT(11) Invoiced DATE payment de DATE 8. Which of the statements below best describes the result set returned by this SELECT statement? SELECT vendor_state, COUNT(*) AS column_2 FROM vendors GROUP BY vendor state HAVING COUNT(*) > 1 A. The names of the vendors in each state B. The duplicate vendors from each state C. The number of vendors in each state D. The number of vendors in each state that has more than one vendor vendors vendor INT(11) vendor_ame VARCHAR(50) vendor_address1 VARCHAR(30) vendor_addr2 VARCHAR(SC) "vender_ VARCHAR(50) verder_state CHAR) *vendor_p_code VARCHAR(20) vendorphone VARCHAR(50) vendor_contact Jast name VARCHAR(50) vendor_contact_first_name VARCHAR(50) default_term_id INT(11) default account number INT(11) 9. Which uses the least amount of storage? A. 'example' stored in a column of type CHAR(20) B. 'exam' stored in a column of type CHAR(20) C 'ex' stored in a column of type CHAR(20) D. they all use the same amount of storage 10. The DATE data type can store A. dates only B. dates and times c. times only D. all of the above Page 3 CISC 460 Mid-Term Exam Revised.docx

Answer 1

6. D) when the same column names exist in both tables.

7. A) the number of rows in the invoices table

8.D) the number of vendors in each state that has more then one vendor

9.D) they all use the same amount of storage

10. A) dates only